Link to home
Start Free TrialLog in
Avatar of sqlserverdba
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?
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial