Restore problem

[cpitc]

Hi

When I try and run a restore from our production to the test database I am getting this error message. Does anyone know what it is and how I can solve it. Thanks

ITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'DB01'. (Microsoft.SqlServer.Smo)

For help, click:

http://go.microsoft.com/fwlink?Prod...ceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: Exclusive access could not be obtained because the database is in use. (Microsoft.SqlServer.Smo)

For help, click:

http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3186.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

 

[SQLBill]

How are you trying to do the restore? Did you create a backup first? Does the database already exist on the test server?

Normally the error about exclusive access means someone is connected to the database. One thing to check...are you connected to the database? You shouldn't be. Make sure you haven't selected the database, instead select Master and run the restore command from there.

Run master..sp_who2 and that will show you who is connected to which databases.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[cpitc]

Hi

I found a solution on line. If you go into services and stop and restart the SQl services, this frees up whereever the lock or process was running. it then allowed me to restore the databse.

Thanks for your reply