Cluster Server 8.0 Implementation Guide for Microsoft SQL Server - Windows
- Section I. Introducing Veritas InfoScale solutions for application high availability
- Understanding the InfoScale solutions for application high availability
- About the VCS agents for SQL Server
- How VCS monitors storage components
- How application availability is achieved in a physical environment
- How is application availability achieved in a VMware virtual environment
- Managing storage and installing the VCS agents
- Installing SQL Server
- Understanding the InfoScale solutions for application high availability
- Section II. Configuring SQL Server in a physical environment
- Overview
- Configuring the VCS cluster
- Configuring the SQL Server service group
- Configuring a SQL Server service group using the wizard
- Making SQL Server user-defined databases highly available
- Verifying the service group configuration
- Administering a SQL Server service group
- Configuring an MSDTC service group
- Configuring the standalone SQL Server
- Configuring an Active/Active cluster
- Configuring a disaster recovery setup
- Section III. Configuring SQL Server in a VMware environment
- Configuring application monitoring using the Veritas High Availability solution
- Administering application monitoring
- Administering application monitoring using the Veritas High Availability tab
- Administering application availability using Veritas High Availability dashboard
- Understanding the dashboard work area
- Section IV. Appendixes
- Appendix A. Troubleshooting
- Error and warning messages from VCS agent for SQL Server
- Troubleshooting application monitoring configuration issues
- Troubleshooting Veritas High Availability view issues
- Appendix B. Using the virtual MMC viewer
- Appendix A. Troubleshooting
Linking clusters: Adding a remote cluster to a local cluster
The VCS Java Console provides a wizard to create global clusters by linking standalone clusters or bringing a standalone cluster into an existing global environment.
You can run the wizard from the following locations:
If you are creating a global cluster environment for the first time with two standalone clusters, run the wizard from either the cluster on the primary site or the cluster on the secondary site.
If you are adding a standalone cluster to an existing global cluster environment, run the wizard from a cluster already in the global cluster environment.
The following information is required for the Remote Cluster Configuration Wizard in Cluster Explorer:
The active host name or IP address of each cluster in the global configuration and of the cluster being added to the configuration.
The user name and password of the administrator for each cluster in the configuration.
The user name and password of the administrator for the cluster being added to the configuration.
InfoScale products do not support adding a cluster that is already part of a global cluster environment. To merge the clusters of one global cluster environment (for example, cluster A and cluster B) with the clusters of another global environment (for example, cluster C and cluster D), separate cluster C and cluster D into standalone clusters and add them one by one to the environment containing cluster A and cluster B.
To add a remote cluster in Cluster Explorer
- From Cluster Explorer, click Add/Delete Remote Cluster on the Edit menu.
or
From the Cluster Explorer configuration tree, right-click the cluster name, and click Add/Delete Remote Cluster.
- Review the required information for the Remote Cluster Configuration Wizard and click Next.
- In the Wizard Options panel, click Add Cluster, then click Next.
- In the New Cluster Details panel, enter the details of the new cluster.
If the cluster is not running in secure mode, do the following:
Enter the host name of a cluster system, an IP address of a cluster system, or the IP address of the cluster that will join the global environment.
If necessary, change the default port number.
Enter the user name.
Enter the password.
Click Next.
If the cluster is running in secure mode, do the following:
Enter the host name of a cluster system, an IP address of a cluster system, or the IP address of the cluster that will join the global environment.
Verify the port number.
Choose to connect to the remote cluster with the credentials used for the current cluster connection, or enter new credentials, including the user name, password, and the domain.
If you connected to the remote cluster earlier through the wizard, you can use the credentials from the previous connection.
Click Next.
- Click Finish. After running the wizard, the configurations on all the relevant clusters are in read-write mode; the wizard does not close the configurations.
- Verify that the heartbeat connection between clusters is alive. From the command window enter hahb -display. The state attribute in the output should show alive.
If the state is unknown, then offline and online the ClusterService group.