MS SQL Server - Cannot Get exclusive access to Database

Author

Cannot Get exclusive access to Database

2005-10-20, 8:23 pm

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

Tibor Karaszi

2005-10-20, 8:23 pm

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
>

Sponsored Links