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 |
|
tgehler
Starting Member
3 Posts |
 Posted - 2014-12-15 : 04:41:07
|
| I installed SQL 12 as a separate instance to my 2008 R2, I must have done it wrong as my msdb became SUSPECT. To get around this I overwrote the 2 msdb files with a colleagues files. That worked, however when I try and restore any of my dbs, I get an error, that msdb is already open and can have one user at a ttime. Error 924.I am very clueless, so ideas/help should be step-by-step! Thanx. |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-12-15 : 05:29:37
|
| is the msdb database in single user mode?Javeed Ahmedhttps://www.linkedin.com/pub/javeed-ahmed/25/5b/95 |
 |
|
|
tgehler
Starting Member
3 Posts |
Posted - 2014-12-15 : 10:16:59
|
| how do I find out? |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-12-16 : 00:49:45
|
| expand the database node under object explorer you will see that the database in single user mode.Javeed Ahmedhttps://www.linkedin.com/pub/javeed-ahmed/25/5b/95 |
|
|
|
tgehler
Starting Member
3 Posts |
Posted - 2014-12-16 : 05:33:55
|
| I think it is in single user mode |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-12-16 : 06:55:34
|
| bring it into multi user mode by running ALTER DATABASE MSDB SET MULTI_USER and then perform the operation whatever you were doing.Javeed Ahmedhttps://www.linkedin.com/pub/javeed-ahmed/25/5b/95 |
|
|
|
|
|
|
Restore error