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.
| Author |
Topic |
|
dba
Starting Member
1 Post |
 Posted - 2003-03-27 : 08:57:03
|
| Hello,i have a DBA that does the database backup but when he is tryingto do the restorage of the backup an error comes up that the databaseis in use. I disconnected all the users but still the same error.there is a way to exclusively denny the DBA of mssql7 to dorestore of a database? is such an option that database mssql7 offers?thanks |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-03-27 : 09:01:52
|
| If you are still getting this error you haven't "disconnected all the users" ....Do a "exec sp_who" to figure out which SPIDs are connected to the db you are trying to restore. Then issue a KILL <spid> for each SPID connected. Make sure you are not connected to the database yourself ...Then do your restore.(Then buy your dba a good book an database administration...)Jay White{0} |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2003-03-28 : 06:07:28
|
| A good idea too, is once you've killed the other users, set the database to single use, or even better, dbo use only to keep people from hopping in there before you kick off your restore code. Nothing more irritating than thinking everyone is out and then someone gets in front of you.Mike"oh, that monkey is going to pay" |
|
|
|
|
|
|
operation