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 |
|
dwalker79
Yak Posting Veteran
54 Posts |
 Posted - 2008-08-10 : 20:06:46
|
| I've got some corruption in my MSDB database and I think I need to restore it from a backup. Is there anything special I need to do when restoring MSDB or is just like restoring any other database? I've never had to restore a system database so I just want to make sure there is nothing special I need to do.Thanks!Dustin |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-10 : 20:49:37
|
Just need to stop the agent to do the restore. You can easily find this out by googling "how to restore msdb". You'll also find the info in Books Online.Here's why the agent must be stopped:quote:
You cannot restore a database that is being accessed by users. If SQL Server Agent is running, it can access msdb. Therefore, before restoring msdb, stop SQL Server Agent.
Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
dwalker79
Yak Posting Veteran
54 Posts |
Posted - 2008-08-10 : 21:23:00
|
| Great, thanks so much for the quick reply! |
|
|
|
|
|
|
MSDB Restore