Veritas Storage Foundation and High Availability Solutions 5.1 SP1 HA and Disaster Recovery Solutions Guide for Microsoft SQL 2000 and 2005 - Windows

Article:DOC3013  |  Created: 2010-09-21  |  Updated: 2010-09-21  |  Article URL http://www.symantec.com/docs/DOC3013
Article Type
Documentation


Description



Table of Contents:
Introduction and Concepts
Introducing Veritas Storage Foundation and High Availability Solutions for Microsoft SQL Server
About clustering solutions with SFW HA
About high availability
How a high availability solution works
About campus clusters
Differences between campus clusters and local clusters
Sample campus cluster configuration
What you can do with a campus cluster
About replication
About a replicated data cluster
How VCS replicated data clusters work
About disaster recovery
What you can do with a disaster recovery solution
What must be protected in an SQL Server environment
Running SQL Server in an active-active clustered environment
Typical SQL Server configuration in a VCS cluster
Typical SQL Server disaster recovery configuration
Where to get more information about Veritas Storage Foundation and High Availability Solutions for Microsoft SQL Server
Configuration Workflows
Configuration workflows for SQL Server
About using the workflow tables
High availability (HA) configuration (New Server)
High availability (HA) configuration (Existing Server)
Tasks for configuring MSDTC for high availability
VCS campus cluster configuration
VCS Replicated Data Cluster configuration
Disaster recovery configuration
DR configuration tasks: Primary site
DR configuration tasks: Secondary site
Using the Solutions Configuration Center
About the Solutions Configuration Center
Starting the Configuration Center
Available options from the Configuration Center
About running the Configuration Center wizards
Following the workflow in the Configuration Center
Solutions wizard logs
Requirements and Planning
Requirements and planning for your HA and DR configurations
Reviewing the requirements
Disk space requirements
Requirements for Veritas Storage Foundation High Availability for Windows (SFW HA)
Supported SQL Server 2000 versions
Supported SQL Server 2005 versions
System requirements for SFW HA
Network requirements for SFW HA
Permission requirements for SFW HA
Additional requirements for SFW HA
Best practices for SFW HA
Reviewing the prerequisites for a standalone SQL Server
Reviewing the HA configuration
Active-Passive configuration
Active-Active configuration
Key information for Active-Active configurations
Following the HA workflow in the Solutions Configuration Center
Reviewing a standalone SQL Server configuration
Sample standalone SQL Server configuration
Reviewing the MSDTC configuration
Reviewing the campus cluster configuration
Campus cluster failover using the ForceImport attribute
Reinstating faulted hardware in a campus cluster
Reviewing the Replicated Data Cluster configuration
Sample replicated data cluster configuration
About setting up a Replicated Data Cluster configuration
About setting up replication
About configuring and migrating the service group
Reviewing the disaster recovery configuration
Sample disaster recovery configuration
IP addresses for sample disaster recovery configuration
Supported disaster recovery configurations for service group dependencies
Deployment
Installing and configuring SFW HA
Configuring the storage hardware and network
Installing Veritas Storage Foundation HA for Windows
Setting Windows driver signing options
Installing Storage Foundation HA for Windows
Resetting the driver signing options
Configuring cluster disk groups and volumes for SQL Server
About cluster disk groups and volumes
Prerequisites for configuring cluster disk groups and volumes
Considerations for converting existing shared storage to cluster disk groups and volumes
Considerations for disks and volumes for campus clusters
Considerations for volumes for a VVR configuration
Considerations for disk groups and volumes for multiple instances
Sample disk group and volume configuration
MSDTC sample disk group and volume configuration
Viewing the available disk storage
Creating a cluster disk group
Creating volumes
About managing disk groups and volumes
Importing a disk group and mounting a volume
Unmounting a volume and deporting a disk group
Adding drive letters to mount the volumes
Deporting the cluster disk group
Configuring the cluster
Configuring Web console
Configuring notification
Installing SQL Server
About installing multiple SQL instances
Verifying that SQL Server databases and logs are moved to shared storage
Installing and configuring SQL Server 2000 on the first cluster node
Installing and configuring SQL Server 2005 on the first cluster node
Installing SQL Server on the second cluster node
Setting the internal name of the clustered instance for SQL Server 2000
Creating a SQL Server user-defined database
Completing configuration steps in SQL Server
Moving the tempdb database if using VVR for disaster recovery
Assigning ports for multiple SQL Server instances
Configuring SQL Server for failover
Configuring the VCS SQL Server service group
Service group requirements for Active-Active configurations
Prerequisites for configuring the service group
Creating the SQL Server service group
Verifying the SQL Server cluster configuration
Configuring an MSDTC Server service group
Prerequisites for MSDTC configuration
Creating an MSDTC Server service group
About configuring the MSDTC client for SQL Server
Configuring MSDTC client on Windows 2003
Configuring MSDTC client on Windows 2008
About the VCS Application Manager utility
Viewing DTC transaction information
Modifying a SQL Server service group to add VMDg and MountV resources
Determining additional steps needed
Configuring campus clusters for SQL Server
Tasks for configuring campus clusters
Modifying the IP resource in the SQL Server service group
Verifying the campus cluster: Switching the service group
Setting the ForceImport attribute to 1 after a site failure
Configuring Replicated Data Clusters for SQL Server
Tasks for configuring Replicated Data Clusters
Creating the primary system zone
Creating a parallel environment in the secondary zone
Adding the systems in the secondary zone to the cluster
Setting up security for VVR
Configuring the VxSAS service
Setting up the Replicated Data Sets (RDS)
Prerequisites for setting up the RDS for the primary and secondary zones
Creating the Replicated Data Sets with the wizard
Configuring a hybrid RVG service group for replication
Creating the RVG service group
Configuring the RVG service group for RDC replication
Configuring the RVGPrimary resources
Configuring the primary system zone for the RVG
Setting a dependency between the service groups
Adding the nodes from the secondary zone to the RDC
Adding the nodes from the secondary zone to the RVG service group
Configuring secondary zone nodes in the RVG service group
Configuring the IP resources for failover
Adding the nodes from the secondary zone to the SQL Server 2000 or 2005 service group
Configuring the zones in the SQL Server service group
Verifying the RDC configuration
Bringing the service group online
Switching online nodes
Additional instructions for GCO disaster recovery
Configuring disaster recovery for SQL Server
Tasks for configuring disaster recovery for SQL Server
Guidelines for installing SFW HA and configuring the cluster on the secondary site
Verifying your primary site configuration
Setting up your replication environment
Setting up security for VVR
Requirements for EMC SRDF array-based hardware replication
Requirements for Hitachi TrueCopy array-based hardware replication
Assigning user privileges (secure clusters only)
Configuring disaster recovery with the DR wizard
Cloning the storage on the secondary site using the DR wizard (VVR replication option)
Creating temporary storage on the secondary site using the DR wizard (array-based replication)
Installing and configuring SQL Server on the secondary site
Cloning the service group configuration from the primary to the secondary site
Configuring replication and global clustering
Configuring VVR replication and global clustering
Configuring EMC SRDF replication and global clustering
Configuring Hitachi TrueCopy replication and global clustering
Configuring global clustering only
Verifying the disaster recovery configuration
Establishing secure communication within the global cluster (optional)
Adding multiple DR sites (optional)
Recovery procedures for service group dependencies
Testing fault readiness by running a fire drill
About disaster recovery fire drills
About the Fire Drill Wizard
About Fire Drill Wizard general operations
About Fire Drill Wizard operations in a VVR environment
About Fire Drill Wizard operations in a Hitachi TrueCopy or EMC SRDF environment
About post-fire drill scripts
Tasks for configuring and running fire drills
Prerequisites for a fire drill
Prerequisites for a fire drill in a VVR environment
Prerequisites for a fire drill in a Hitachi TrueCopy environment
Prerequisites for a fire drill in an EMC SRDF environment
Preparing the fire drill configuration
System Selection panel details
Service Group Selection panel details
Secondary System Selection panel details
Fire Drill Service Group Settings panel details
Disk Selection panel details
Hitachi TrueCopy Path Information panel details
HTCSnap Resource Configuration panel details
SRDFSnap Resource Configuration panel details
Fire Drill Preparation panel details
Running a fire drill
Recreating a fire drill configuration that has changed
Restoring the fire drill system to a prepared state
Deleting the fire drill configuration
Reference
Configuring disaster recovery without the DR wizard
Tasks for configuring disaster recovery without the DR wizard
Guidelines for installing and configuring SFW HA and the cluster on the secondary site
Creating a parallel environment on the secondary site
Setting up the Replicated Data Sets (RDS)
Prerequisites for setting up the RDS for the primary and secondary zones
Creating the Replicated Data Sets
Creating the VVR RVG service group
Configuring the global cluster option for wide-area failover
Prerequisites
Linking clusters: Adding a remote cluster to a local cluster
Converting a local service group to a global service group
Bringing a global service group online
Index

 


Attachments

SFW_HA_DR_SQL_Solutions_51SP1.pdf (2.9 MBytes)

Article URL http://www.symantec.com/docs/DOC3013


Terms of use for this information are found in Legal Notices