July 6, 2005 at 12:13 pm
Hello all,
I tried to restore database by using UNC name
restore database Test3
from disk = '\\servername\sharename\test3.bak'
with recovery
and i got this error.
i am using domain account and i have full rights of share folder.plese help me
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.
Thanks
July 6, 2005 at 1:52 pm
The problem is there are users in the database at the time of the restore. The user could even be you. Make sure you're not in the database at the time (if you're running from Query Analyzer, make sure the database drop down is on master). Also, you can set the database for single user or restricted user mode using the ALTER DATABASE command if you are having trouble keeping folks out.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply