Recovering a SQL Server cluster group and resources
如何將誤刪的SQL Server Cluster Group加回
1.Create a new SQL Server resource group in Failover Cluster Manager.
(1)Click [Services and Applications] and then, under Actions (on the right), click [Configure a Service or Application]。
(2)Select [Other Server]。
(3)Set SQL Server Cluster Virtual Name(SQL Network Name) and SQL Server Virtual IP。
(4)Select your SQL Server Shared Disk。
(5)Select SQL Server and SQL Server Agent。
2.Change “New SQL Server” resource name to “SQL Server”。
3.Change “New SQL Server Agent” resource name to “SQL Server Agent”。
4.Setup the dependencies for “SQL Server” resource，depend on shared disk and Network name resource，check [Run this resource in a separate Resource Monitor]。
5.Setup the dependencies for “SQL Server Agent”， depend on “SQL Server” resource，check [Run this resource in a separate Resource Monitor]。
6.On the active node, open CMD, run the following commands.<重要步驟>
cluster res "SQL Server" /priv VirtualServerName=SQLCLUST1
cluster res "SQL Server" /priv InstanceName=MSSQLSERVER
cluster res "SQL Server Agent" /priv VirtualServerName=SQLCLUST1
cluster res "SQL Server Agent " /priv InstanceName=MSSQLSERVER
PS.SQLCLUST1 is your SQL Network Name, MSSQLSERVER is your SQL Instance Name
7. On the active node, open CMD, run the following commands，對SQL Server Network Name resource設定Checkpoint (Registry replication)
cluster res "sqlclust1" /addcheckpoints:"SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\Cluster"
cluster res "sqlclust1" /addcheckpoints:"SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQLServer"
cluster res "sqlclust1" /addcheckpoints:"SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\Replication"
cluster res "sqlclust1" /addcheckpoints:"SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\Providers"
cluster res "sqlclust1" /addcheckpoints:"SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\SQLServerSCP"
cluster res "sqlclust1" /addcheckpoints:"SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\CPE"
cluster res "sqlclust1" /addcheckpoints:"SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\SQLServerAgent"
8. Try to bring SQL Server resource online and try to test failover.
9. (Optional) rename SQL Virtual IP Address resource name and SQL Network Name
cluster res "sqlclust1" /rename:"SQL Network Name (sqlclust1)"
[Reference]
How to manually re-create the resource-specific registry keys for SQL Server cluster resources
https://support.microsoft.com/kb/810056/en-us
How to change SQL Server parameters in a clustered environment when SQL Server is not online