sql server restore master database to another server

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. She primarily focuses on the database domain, helping clients build short and long term multi-channel campaigns to drive leads for their sales pipeline.First published on TECHNET on Feb 01, 2011

Nupur Dave is a social media enthusiast and an independent consultant. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at. Pinal has authored 13 SQL Server database books and 45 Pluralsight courses. He holds a Masters of Science degree and numerous database certifications. Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 17 years of hands-on experience.

Sql server restore master database to another server