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 |
|
Linica
Starting Member
1 Post |
 Posted - 2007-12-08 : 22:47:11
|
| Could anybody give a lead as to what I can do get rid off this error please. I alread tried following:use mastergoAlter Database dbname set single_user with rollback immediate;goStill have the issue. SQL 2005 Server actually did lock the db.So ran Alter Database dbname set multi_user;go and refresh Query and it switch back to multi user. But I can't restore db yet. Thank you |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-08 : 23:17:01
|
| Multi user is fine as long as no user connect to the db. Check user connections with sp_who, and stop them with kill command. |
 |
|
|
|
|
|
Exclusive access could not be obtained because the