Storage Foundation and High Availability Solutions 8.0.2 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
- Notes and recommendations
- 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
Configuring the storage hardware and network
Use the following procedures to configure the hardware and verify DNS settings. Repeat this procedure for every node in the cluster.
To configure the hardware
- Install the required network adapters, and SCSI controllers or Fibre Channel HBA.
- Connect the network adapters on each system.
To prevent lost heartbeats on the private networks, and to prevent VCS from mistakenly declaring a system down, Veritas recommends disabling the Ethernet autonegotiation options on the private network adapters. Contact the NIC manufacturer for details on this process.
Veritas recommends removing TCP/IP from private NICs to lower system overhead.
- Use independent hubs or switches for each VCS communication network (GAB and LLT). You can use cross-over Ethernet cables for two-node clusters. LLT supports hub-based or switch network paths, or two-system clusters with direct network links.
- Verify that each system can access the storage devices. Verify that each system recognizes the attached shared disk and that the attached shared disks are visible.
To verify the DNS settings and binding order for all systems
- Open the Control Panel by clicking Start > Control Panel.
- Click Network and Internet, and then click Network and Sharing Center.
- In the Network and Sharing Center window, on the left side of the screen under Tasks, click Adapter settings.
- Ensure the public network adapter is the first bound adapter by following these steps sequentially:
In the Network Connections window, click Advanced > Advanced Settings.
In the Adapters and Bindings tab, verify the public adapter is the first adapter in the Connections list. If necessary, use the arrow button to move the adapter to the top of the list.
Click OK.
- Open the Public status dialog box by doing one of the following in the Network Connections window:
Double-click the adapter for the public network.
Right-click the adapter for the public network and click Status.
Select the adapter for the public network and click View status of this connection in the toolbar.
When enabling DNS name resolution, make sure that you use the public network adapters, and not those configured for the VCS private network.
- In the Public Status dialog box, on the General tab, click Properties.
- In the Public Properties dialog box, on the General tab, select the appropriate IP version and then click Properties.
- Select the Use the following DNS server addresses option.
- Verify the correct value for the IP address of the DNS server.
- Click Advanced.
- In the DNS tab, make sure that the Register this connection's address in DNS check box is selected.
- Make sure that the correct domain suffix is entered in the DNS suffix for this connection field.
- Click OK.