InfoScale™ 9.0 Storage Foundation and High Availability Solutions HA and DR Solutions Guide for Microsoft SQL Server - Windows
- Section I. Getting started with Storage Foundation and High Availability Solutions for SQL Server
- Introducing SFW HA and the VCS agents for SQL Server
- How is application availability achieved in a VMware virtual environment
- How VCS monitors storage components
- Deployment scenarios for SQL Server
- Reviewing the active-passive HA configuration
- Reviewing a standalone SQL Server configuration
- Reviewing the campus cluster configuration
- Reviewing the Replicated Data Cluster configuration
- About setting up a Replicated Data Cluster configuration
- Disaster recovery configuration
- Reviewing the disaster recovery configuration
- Notes and recommendations for cluster and application configuration
- Configuring disk groups and volumes for SQL Server
- About managing disk groups and volumes
- Configuring the cluster using the Cluster Configuration Wizard
- Installing SQL Server
- Completing configuration steps in SQL Server
- Introducing SFW HA and the VCS agents for SQL Server
- Section II. Configuring SQL Server in a physical environment
- Configuring SQL Server for failover
- About configuring the SQL Server service group
- Configuring the service group in a non-shared storage environment
- Configuring an MSDTC Server service group
- Configuring campus clusters for SQL Server
- Configuring Replicated Data Clusters for SQL Server
- Setting up the Replicated Data Sets (RDS)
- Configuring a RVG service group for replication
- Configuring the resources in the RVG service group for RDC replication
- Configuring the VMDg or VMNSDg resources for the disk groups
- Configuring the RVG Primary resources
- Adding the nodes from the secondary zone to the RDC
- Verifying the RDC configuration
- Configuring disaster recovery for SQL Server
- Setting up your replication environment
- About configuring disaster recovery with the DR wizard
- Configuring replication and global clustering
- Configuring the global cluster option for wide-area failover
- Testing fault readiness by running a fire drill
- About the Fire Drill Wizard
- Prerequisites for a fire drill
- Preparing the fire drill configuration
- Deleting the fire drill configuration
- Configuring SQL Server for failover
Adding the nodes from the secondary zone to the RVG service group
Use the Volume Replicator Agent Configuration Wizard to add the nodes from the secondary zone to the RVG.
Note:
In case of a non-shared storage environment, perform this task manually using the Java Console. You cannot use the wizard to modify the RVG service group.
Use the following procedure if the RVG service group contains a VMDg resource (shared storage environment).
To add the nodes from the secondary zone to the RVG
- From the active node of the cluster in the primary zone, launch the Volume Replicator Agent Configuration Wizard from the Apps menu on the start screen.
- Read and verify the requirements on the Welcome page, and click Next.
- In the Wizard Options panel, specify the following:
Click Modify an existing replication service group. The existing replication service group is selected, by default.
Click Next.
- If a VCS notice message appears, asking if you want to continue, click Yes.
- Specify the system priority list as follows:
In the Available Cluster Systems box, click the nodes in the secondary zone to add to the service group, and click the right-arrow icon to move the nodes to the service group's system list.
To remove a node from the service group's system list, click the node in the Systems in Priority Order box, and click the left arrow icon.
To change the priority of a node in the system list, click the node in the Systems in Priority Order box, then click the up and down arrow icons. The node at the top of the list has the highest priority.
To enable the service group to automatically come online on one of the systems, select the Include selected systems in the service group's AutoStartList attribute checkbox.
For information about the AutoStartList attribute, see the Cluster Server Administrator's Guide.
Click Next.
- If a message appears, indicating that the configuration will be changed from Read Only to Read/Write, click Yes to continue.
- Review the Disk Group and Replicated Volume Group Configuration and click Next.
- In the IP Resource Options panel, select Modify IP resource and click Next.
- If a VCS error appears, click OK.
- In the Network Configuration panel, verify that the selected adapters are correct and click Next.
- Review the summary of the service group configuration as follows:
The Resources box lists the configured resources. Click a resource to view its attributes and their configured values in the Attributes box.
Click Next to modify the replication service group.
- When prompted, click Yes to modify the service group.
- Click Finish.
Use the following procedure if the RVG service group contains a VMNSDg resource (non-shared storage environment).
To add nodes from the secondary zone to the RVG service group using Java Console
- From VCS Cluster Explorer, in the left pane, right-click the RVG service group and select View > Properties View.
- In the Attributes window, click Show all attributes.
- From the attributes list, select the attribute SystemList and click the edit icon.
- In the Edit Attribute window, edit the SystemList attribute as follows:
Click the + button to add an empty row.
In the System field type the cluster node name from the secondary zone.
In the Priority field type 1.
Click OK.
- Close the Attributes window.