Restoring the Microsoft SQL Server master database running on a DxConsole or DxEnterprise cluster.
This is very much the same as how you would do so with a stand-alone instance. There are really just two additional steps you need to take to successfully restore a master database:
- Freeze the VHost before restoring master
- Unfreeze the VHost after restoring master
The following is a general procedure that you can use to restore the master database:
- Remote Desktop into the active node that is currently hosting the instance
- Launch DxAdmin management console (formerly DxConsole or DxEnterprise management console)
- Right-click on the active node under the VHost and select "Freeze virtual host on node"
- Open Regedit and browse to the instance key (e.g. HKLM\Software\Microsoft\Microsoft SQL Server\<instance_name>\MSSQLServer\Parameters) and add SQLArg3 with string value of “-m”. This puts the instance under single-user startup mode so you can restore master. Restart the instance service to take effect.
- Restore master database. See http://msdn.microsoft.com/en-us/library/ms190679(v=sql.105).aspx for additional info.
- Once master is restored, again using Regedit to remove the single-user startup parameter. Restart the instance service to take effect.
- Back to the DxAdmin management console, right-click on the frozen node under the VHost and select "Unfreeze virtual host on node" to put the VHost back into normal operation again.
- DxEnterprise 15.0
- DxEnterprise 15.5
- DxEnterprise 16.0
- Microsoft SQL Server