Breaking a SQL Cluster

Question

Hi All

We are currently running a 2 node SQL 2012 Cluster(VM's) built using the MSFC. The servers uses RDM based disks.

Now , we need to Break the cluster , and make it a as a single DB server.

I would appreciate if somebody could share there experiences in this regard.

Answer 1

Hi,

Basically you just need to remove the node from the Failover Cluster.

Step one will always be to backup everything and confirm your full backup can be restored

next simply follow step by step in the Microsoft document:

https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/install/add-or-remove-nodes-in-a-sql-server-failover-cluster-setup?view=sql-server-ver15#Remove

Answer 2

Hi @Muraleedaran Kanapathy ,

You would need to move all of the SQL Server cluster resources to one of the nodes, evict the node and destory cluster, and then rebuild the standalone

Break the existing SQL cluster

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Hi All

Thank you for your feedback.

What I am thinking is , if we evict the passive node and the let the cluster run with a single node

• How can I remove the cluster services and turn the server in to a single node installation?
• Secondly is there any way to migrate the data from the RDM based disks to VMDK ?
  (my environment is running on VMware).

Best regards