- Assume the SQL server was shutdown gracefully.
- Remove Windows Cluster Role:
- Remove the server from cluster (only needed if you cannot remove Cluster feature at Windows Server)
- Run powershell as an administrator
- Enter: Import-Module FailoverClusters
- then clear-clusternode
- Remove Cluster Service.
- Reboot the server
- Go to Disk Management, online those cluster disk manually. Then you can find those disk at Windows Explorer
- Add the virtual IP(s) to NIC
- Add the DNS A record to DNS server of old SQL virtual hostname
- Remove dependency of Cluster service to SQL server
- Change registry key SqlCluster in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\Setup\ from 1 to 0
- Take a backup and delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\Cluster
- Start SQL server via Services
- Change SQL service start mode from Manual to Automatic.
Tested on Windows 2012 + SQL 2012, and Windows 2008 + SQL 2008
Comments