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 |
|
cipfaadmin
Starting Member
6 Posts |
 Posted - 2004-11-16 : 03:41:27
|
| Hi, sorry for such simple question here but it's the first time i've had to do this. I need to start a database into single user mode to restore the master / model, etc.. databases but whenever I use the command line to start it up in single user mode and then try to go into enterprise manager or sql analyser to run the restore's it says that only one dbo can be logged in at a time. Can anyone let me know how to get around this please.I'm using server 2000Thanks in advance.Michael Bailey. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-16 : 18:26:25
|
| Somebody else must be getting into the server before you do it because it sounds like you are doing it right. So you need to make sure everyone is disconnected, this includes applications that connect automatically like web sites.Tara |
 |
|
|
|
|
|
Single User Mode