Search This Blog

SQL Server Restore Master Database


It is very important to have the full backups of Master Database. Although it is very rare to have the need to Restore the Master Database but we should always be well equipped to counter those rarest occasions.
It is relatively easier process:
  1. It is mandatory to start SQL Server Instance in Single User Mode. To start SQL Server instance in Single User mode, you can refer this article.
  2. Once the SQL Server starts in Single User mode, connect to SQLCMD and run the below command:
    RESTORE DATABASE [Master] FROM DISK=‘C:\Subhro\Master_20120626.bak’WITHREPLACE;
    GO