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
 General SQL Server Forums
 New to SQL Server Administration
 Restore error

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 Ahmed
https://www.linkedin.com/pub/javeed-ahmed/25/5b/95
Go to Top of Page

tgehler
Starting Member

3 Posts

Posted - 2014-12-15 : 10:16:59
how do I find out?
Go to Top of Page

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 Ahmed
https://www.linkedin.com/pub/javeed-ahmed/25/5b/95
Go to Top of Page

tgehler
Starting Member

3 Posts

Posted - 2014-12-16 : 05:33:55
I think it is in single user mode
Go to Top of Page

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 Ahmed
https://www.linkedin.com/pub/javeed-ahmed/25/5b/95
Go to Top of Page
   

- Advertisement -