Surendra Sharma

Surendra Sharma

Search This Blog

Monday, August 8, 2016

How to bring database from recovery mode to normal mode



I have published my last article about database restore. This article is also related with database.

I was trying to restore my Sitecore database from script, but that database was in recovery mode. If you try to restore any database which is in recovery mode, you will get sql error

Msg 3101, Level 16, State 1, Line 2
Exclusive access could not be obtained because the database is in use.
RESTORE DATABASE is terminating abnormally.

How to change any database mode from recovery to normal?

Solution:

There may be scripts and other option related with this but I suppose below is pretty straight forward way.

To remove recovery mode 

1. You need to offline database by Right click on Database -> Tasks -> Take Offline as 





2. Bring database to online by Right click on Database -> Tasks -> Bring Online as


 

Please leave your comments or share this trick if it’s useful for you.

No comments:

Post a Comment