How to Restore Corrupt Master Database in SQL Server
- This topic has 7 replies, 7 voices, and was last updated 8 years, 4 months ago by .
-
Posts
-
Do you have backup of master database?
That is the first question. Do you have a master backup? The easiest way that i know is to install a new instance restore the master backup and attach the databases.
Copy the MDF and LDF files from the binn (templates) folder and paste them in the data folder and after that open in master only mode and restore the backup which you have and change the path of other databases if required.
When master gets corrupted. You can rebuild it if you don’t have backup
Restore master database from latest backup by the master restoration process. Rebuilding master is not recommended as it would loose logins and multiple other DB objects.
Two ways recover the master database
1.Restore the master database
2.Rebuild the master database
- You must be logged in to reply to this topic.