Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 restore database

Author  Topic 

abc
Starting Member

48 Posts

Posted - 2003-02-19 : 04:59:02
Hi
I'm using a SQL server, and it have to run round-oclock. Now I want to restore data for a database running on that SQL server. What have I do whenever I restore there is alway an error message "...Administrator have to exclusive use of database...".
Please tell mee the way to do....
Thanks

Thanks for your attention

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2003-02-19 : 05:32:34
In order to restore database you will need to be the only one using it.
This is true even for the connections that you may have made thru EM.
You can exit EM and thru QA perform your restore.

HTH.
Franco

Go to Top of Page
   

- Advertisement -