sqlserverdba
asked on
sql restore error database in use
Server: Msg 3101, Level 16, State 2, Line 1
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
this was the error when i tried to use restore command with replace on an existing database. i checked the activity monitor, there is a process for the database that has status 'sleeping'. could that be the problem?
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
this was the error when i tried to use restore command with replace on an existing database. i checked the activity monitor, there is a process for the database that has status 'sleeping'. could that be the problem?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.