February 26, 2002 at 11:31 am
On our test server, we installed a third-party software which corrupted the master DB and over the weekend SQL server did not come up for that reason. Is there a way of restoring master from backup without having to re-install SQL server. SQL server does not come up in the first place; how do I go about doing this??
Raghu
Raghu
February 26, 2002 at 12:15 pm
You can use the rebuildm.exe command from the command line. Make sure you have a SQL Server CD. This will replace the master, model, and msdb databases (so if you need to save msdb, you might want to copy it off). When you restart SQL Server with the new master database, restore from backup.
BTW, this is how we operate in Disaster Recovery solutions. We do a file restore, which puts everything on the server except for the .mdf, .ndf, and .ldf files. We run rebuildm.exe, and then we restore the system databases followed by the user databases.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply