Couldn't restore database

Question

Hi!

WE could not restore the database of Solarwinds Orion.  The ff. error was encountered:

SQL Server exclusive access could not be obtained because the database is in use.

RESTORE DATABASE is terminating abnormally.

Need help for this.

Thanks

roselyn · Answer

Hi Savell,

We'll try it.

Thanks,

Roselyn

savell · Answer

As per the error message, it looks like you don't have exclusive access to the database (i.e. there are other connections active).

You may want to put the database you are trying to restore into single user mode. Here's an explanation from a quick google search http://www.mssqltips.com/tip.asp?tip=1407

Dave.