Home Forums SQL Server 2005 Backups How to restore master database in a SQL Server 2005 Cluster RE: How to restore master database in a SQL Server 2005 Cluster

  • Follow below steps for restoring master database in SQL Server 2008 R2 failover cluster

    1.Put SQL Server in Single user mode in SQL Server Configuration manager

    (Put -m in SQL Server startup parameters and Offline SQL Server Agent)

    2.Restart SQL Services from Failover cluster manager and make SQL Server Group online

    3.Open CMD with Administrator privileges

    4.Type NET START MSSQL$name(named instance) in command prompt or type

    NET START MSSQLSERVER (Default instance)

    5.Type SQLCMD -S instance name (named instance) in command prompt or type

    SQLCMD (Default instance)

    6.Run Restore command RESTORE DATABASE master FROM DISK = '’ WITH REPLACE;