After installing CDC Replication on
the SQL Server cluster node that owns the shared disk array, you must
add an instance using the configuration tool.
Procedure
- Start the configuration tool and add a new instance that
specifies the port that the clustered SQL Server is listening on.
Note: Do not start the instance after you add it.
- Run the following command in the bin folder
in your CDC Replication installation
directory:
dmcreateclusterservice -I <instance_name> <passive_node_name>
where:
<passive_node_name> is
the name of the passive node in the cluster.
- Using the cluster administration tools in your version
of Microsoft Windows, examine the SQL Server cluster group.
- Create a new Generic Service resource in the SQL Server
cluster group for each CDC Replication instance.
You must ensure that each new cluster resource depends on
the SQL Server resource and enter the service name. The service name
must use the following format:
dmtssql_<instancename>
where dmtssql_ is
the standard prefix and <instancename> is the CDC Replication instance
name.
- Right-click the service name to display the properties
and deselect the Affect the group check box.
This will prevent Microsoft SQL
Server from failing over when the CDC Replication service
fails or is manually stopped.
- Bring the new cluster resources
online.
What to do next
After completing this task, CDC Replication will
work in a clustered environment and support failover of its services.You
should also note the following when using CDC Replication in
a clustered environment:
- Subscriptions must be restarted after a failover
- All CDC Replication applications
such as services, the configuration tool, and command line utilities
must be run from the active node in the cluster since application
files are stored on the shared disk and you can only access the active
node in the cluster.
- There are no Windows Start
menu shortcuts on the passive node.