Recovering MSDB Database

[Ziggy]

1) How do I reinstall a fresh copy of the MSDB database (since my current
one is corrupt). Is there any script available?

2) What is the purpose of the MSDB database? Backups and jobs/ Wizards?

Thanks for your help.
Ziggy

[Mike John]

You can recreate MSDB by using the rebuildm utility from the command line. This will also recreate MASTER and MODEL so it is essential that you have appropriate backups of at least MASTER before doing so.

You DO have backups of MSDB don't you? If not you really,really should have!

MSDB contains:
Jobs,Alerts,Operators,DTS packages and details of backup and restore history of all databases on the server. Normally easiet to back it up (and MASTER) on a daily basis to avoid problems.

Depending on the nature of the corruption you *may* be able to rescue things by selectively copying tables out or using DBCC - exactly what is corrupt?


HTH

Mike John

KnowledgePool Ltd


------------
Ziggy at 5/31/00 9:25:22 AM

1) How do I reinstall a fresh copy of the MSDB database (since my current
one is corrupt). Is there any script available?

2) What is the purpose of the MSDB database? Backups and jobs/ Wizards?

Thanks for your help.
Ziggy

[Shea]

The quickest way would be if you have a backup. Just restore it from disk or
tape.

- You could also rebuild the master db; which will recreate all system dbs.
- MSDB contains all information that relates to scheduled jobs, alerts, and
operators that get notifications.

Also look at BOL (Books on Line)

GOOD LUCK..


------------
Ziggy at 5/31/00 9:25:22 AM

1) How do I reinstall a fresh copy of the MSDB database (since my current
one is corrupt). Is there any script available?

2) What is the purpose of the MSDB database? Backups and jobs/ Wizards?

Thanks for your help.
Ziggy