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
Setting up the Active/Active cluster
Perform the following tasks to configure an active-active SQL Server cluster.
Table: Tasks to set up an active-active SQL Server cluster
Task | Description |
---|---|
Install Veritas InfoScale Availability and configure the VCS cluster | Install Veritas InfoScale Availability on all the systems where you want to configure an application for availability and configure a VCS cluster. For details refer to theVeritas InfoScale Installation and Upgrade Guide. See About installing the VCS agents. See Configuring the cluster using the Cluster Configuration Wizard. |
Configure volumes or virtual disks for SQL Server | For each instance of SQL Server (SQL Server system data files and the registry keys replicated among cluster nodes), create volumes or LUNs (virtual disks) on the shared storage. |
Install the first instance of SQL Server | Consider the following points while you install the first instance of SQL Server:
|
Configure the service group for the first SQL Server instance | Consider the following points as you configure the SQL Server service group for the first instance:
|
Configure the service group for user-defined databases, if any | You can use VCS to manage user-defined SQL Server databases. Create the required SQL databases using the SQL Server Management Studio and then make them highly available with VCS. See Making SQL Server user-defined databases highly available. |
Repeat the SQL Server installation and service group configuration for additional instances | To install and configure one or more additional SQL Server instances, follow the same procedures as when installing the first instance. Make the same changes to the process, as follows:
See About installing SQL Server on the first system. Consider the following points as you configure the SQL Server service groups for the additional instances:
See About configuring the SQL Server service group. Configure the service group for user-defined databases, if any. See Making SQL Server user-defined databases highly available. |
Verify the configuration |