Thursday, February 16, 2012

Cannot Get exclusive access to Database

Hi
My database is warm standby state (loading). Prior to this I truncated the
log file. I need to restore the log file but I cannot get exclusive access.
I tried RESTORE DATABASE abcd WITH RECOVERY and I get error 3101 (cant get
exclusive access) followed by error 3013.
Please assist.
Mmany thanks for your time and efforts
JMRun sp_who to see who is connected. Use KILL to throw out the users. Make sure you are in the master
database when you execute the RESTORE command.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"JM" <JM@.nowhere.com> wrote in message news:11l7sokg3i94ra9@.corp.supernews.com...
> Hi
> My database is warm standby state (loading). Prior to this I truncated the log file. I need to
> restore the log file but I cannot get exclusive access.
> I tried RESTORE DATABASE abcd WITH RECOVERY and I get error 3101 (cant get exclusive access)
> followed by error 3013.
> Please assist.
> Mmany thanks for your time and efforts
> JM
>

No comments:

Post a Comment