September 20, 2002 at 10:59 am
Hi, am new to SQL.Peharps somebody could give me a hint on what to do:
The Problem is when trying to restore a database i get the following error :
[Microsoft][ODBC SQL Server Driver][SQL Server]Database in use.The system Administrator must have exclusive use of the database to run the restore operation.
[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation terminating abnormally.
From what i know, i am the only user connected to the database (am the only existing user).
I can Backup the database but no restore is possible.
Thanks, in advance!
Edited by - mainman03 on 09/20/2002 11:01:18 AM
September 20, 2002 at 11:11 am
Perhaps you are the only user, but have multiple connections. This happens to me when I have a QA window open on a DB and try to restore the DB from EM. I would check current activity in EM under the Managemetn folder to see how many connections are associated with the database you are trying to restore. Hope this helps.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
September 20, 2002 at 11:40 am
you need to run thsi from master, not the database. If you have EM open with the database selected, you are "using the database". You need to be connected to the server, but NOT the database. Use another database like master to run the restore.
Steve Jones
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply