Recovering MSDB - SQL Server Forums

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

SQL Server 2000 Forums

SQL Server Administration (2000)

Recovering MSDB

Author

Topic

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2006-08-17 : 13:46:34

I am building a replacement server for our main SQL server.
It is currently not even connected to the net.
I have restored the master DB in single user mode and then restarted the server.
However when I go to restore the MSDB I get an error.

Exclusive access could not be obtained because database is in use.

Tara where are you????

Jim
Users <> Logic

nr
SQLTeam MVY

12543 Posts

Posted - 2006-08-17 : 13:55:41

Have a look at sysprocesses and see what is using the database.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2006-08-17 : 14:06:05

I do not see anything useing it.
Heck I just did the install and its currently a stand alone box.
What the heck could be useing it other than EM or QA?

Jim
Users <> Logic

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-08-17 : 14:09:54

Well something is using it. When you checked sysprocesses, you didn't see a single connection to msdb. Here's the query to run:

select * from sysprocesses
where DB_NAME(dbid) = 'msdb'

Tara Kizer

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2006-08-17 : 14:23:15

Found it.

Sorry folks this head cold has given me a bad case of dumbasss.

When I rebooted the SQL Server Agent restarted.

Thanks

Jim
Users <> Logic

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2006-08-18 : 03:13:06

>> When I rebooted the SQL Server Agent restarted.
Rebotting solves many problems!! Its a panacea...

------------------------
I think, therefore I am - Rene Descartes

DMcCallie
Yak Posting Veteran

62 Posts

Posted - 2006-08-18 : 10:29:47

Stop the SQL Server Agent then restore MSDB...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources