Problem Description:

Database restore on non-prod database failed with below error.

Msg 3101, Level 16, State 1:
Server 'ASESRV', Line 1:
Database in use. A user with System Administrator (SA) role must have exclusive use of database to run load.… Read the rest