July 3, 2002 at 12:55 pm
I got the following error message when restoring databases:
"Exclusive access could not be obtained because database is in use. "
However, I am the only one is opening the ER right now and no one else is using the database. Can anyone tell me what is other thing to check and what could cause this problem?
Thank you in advance.
July 3, 2002 at 2:26 pm
Run an EXEC sp_who2 and that should tell you what SPIDs are accessing the database.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
July 3, 2002 at 3:39 pm
A lot of times it will be you - if you open QA to that db or click on the db in EM, you'll have a connection.
Andy
July 3, 2002 at 4:39 pm
I use the "exec sp_who2" to check, the databas is indeed used by me. And I need to restore the new data to this database, what is the correct way to do so? I thought (I think I did it before), I just right click on that database and do a "All tasks -> restore database". Is it not right?
July 8, 2002 at 10:12 am
USE a different db( like master).
Steve Jones
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply