September 22, 2009 at 1:41 pm
Is there a way to revert the Master and MSDB database back to their initial configration after install without uninstalling and reinstalling SQL Server?
September 22, 2009 at 1:56 pm
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
Consultant - Straight Path Solutions
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
September 22, 2009 at 1:59 pm
No backups on our QA servers, so it will be option #3.
Thanks Jack!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply