Deleting an instance from a Microsoft SQL Server cluster

You can remove a CDC Replication instance from a Microsoft SQL Server cluster.

Procedure

  1. Use the Microsoft Cluster Administrator tool to take the cluster resource for the service offline.
  2. Delete the cluster resource.
  3. From the active node in the cluster, launch the CDC Replication configuration tool.
  4. Delete the instance for the active node.
  5. From the passive node in the cluster, delete the service using the following command:

    sc delete dmtssql_<instancename>

    where dmtssql_ is the standard prefix and <instancename> is the CDC Replication instance name.