RE: Restore Database Failed: 'Exclusive access could not be obtained because the database is in use.'

SSCarpal Tunnel

Points: 4473

September 27, 2012 at 4:48 am

Make sure no other instances of SSMS are open.

If you have multiple tabs open, make sure they are not pointing to the DB in question.

You could also try restarting the service.

Any replication going on? Or any other jobs or triggers pointing to your troublesome DB?

For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

"Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort