rebuild master database in sql server 2012 step by step

Now you're ready to try starting the SQL Server service again!īecause the master database is usually very small, this method should just take a few minutes, it should work for all versions of SQL Server, and it works for both stand-alone instances and clustered instances. Delete the corrupt master.mdf and mastlog.ldf files, rename recover_master.mdf to master.mdf, and rename recover_master_1.ldf to mastlog.ldf. The recover_master database, go into the file system, copy the recover_master.mdf and recover_master_1.ldf to the instance of SQL Server with the corrupt master database. This will cause the mdf/ldf to be named 'recover_master.mdf' and 'recover_master_1.ldf'. Restore your master database backup to another instance of SQL Server and in the 'To database:' section of the Restore Database dialog box, use an alternate database name such as 'recover_master' to avoid conflict with the master database on this instance of SQL Server. You can restore a backup of the master database on another instance of SQL ServerĪs long as it's the same version of SQL Server, then use the restored files to replace the corrupt files on the broken system.

The easiest way to rebuild the SQL Server master database is: It can be so troublesome, a lot of people consider reinstalling SQL Server from scratch! If that's what you're facing, then this may be a big help. But rebuilding the master database is usually quite time-consuming and frustrating, with a substantial amount of trial-and-error, especially if it's on a cluster. That's because SQL Server won't start with a corrupt master database.

If your SQL Server master database becomes corrupt, such as from its disks losing power while SQL Server was running, the conventional advice is to rebuild the master database, start SQL Server, then restore the backup of the master database. First published on TECHNET on Feb 01, 2011

Rebuild master database in sql server 2012 step by step