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
JM
Run 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