Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

System database corrupted Expand / Collapse
Author
Message
Posted Tuesday, September 22, 2009 1:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 08, 2011 9:44 AM
Points: 6, Visits: 61
Is there a way to revert the Master and MSDB database back to their initial configration after install without uninstalling and reinstalling SQL Server?
Post #792147
Posted Tuesday, September 22, 2009 1:56 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:24 AM
Points: 10,907, Visits: 12,540
You can restore msdb like any other database, http://msdn.microsoft.com/en-us/library/ms190749(SQL.90).aspx, if you have a backup. You can also restore master as well, http://msdn.microsoft.com/en-us/library/ms190679(SQL.90).aspx, if you have a backup.

If you do not have backups then you will have to rebuild master, http://msdn.microsoft.com/en-us/library/ms191431(SQL.90).aspx




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #792163
Posted Tuesday, September 22, 2009 1:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 08, 2011 9:44 AM
Points: 6, Visits: 61
No backups on our QA servers, so it will be option #3.

Thanks Jack!
Post #792168
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse