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 su
re 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...reen">
> 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