My master database got corrupted, how can I restore corrupted master database in SQL Server
How to Restore Corrupt Master Database in SQL Server
Resolved
SQL
CM
Community Member June 18, 2016
7 replies
1,164 views
Reviewed by moderators
7 Answers
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.
Yes, I have the backup
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 n1. Restore the master database n2. Rebuild the master database