Veritas Storage Foundation and High Availability Solutions 5.1 SP1 Microsoft Clustering Solutions Guide for Microsoft SQL 2008 - Windows

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


Description



Table of Contents:
Introducing SFW solutions for a Microsoft cluster
About Microsoft clustering solutions with SFW
About the solutions guides
How this guide is organized
Advantages of using SFW in a Microsoft cluster
About high availability clusters
About campus clusters
About disaster recovery clusters
Workflows for deploying SQL 2008 with SFW in a Microsoft cluster
Workflow for a high availability (HA) configuration
Workflow for a campus cluster configuration
Workflow for a disaster recovery configuration
Using the Solutions Configuration Center workflow
Planning for deploying SQL 2008 with SFW in a Microsoft cluster
Requirements for deploying SQL Server 2008 with SFW in a Microsoft cluster
Supported software for Microsoft clustering and SFW
Disk space requirements
System requirements
Additional installation requirements
Planning your high availability configuration
Sample high availability configuration for SQL Server with SFW
Configuring the quorum device for high availability
Planning your campus cluster configuration
Microsoft campus cluster failure scenarios
Microsoft cluster quorum and quorum arbitration
Planning your disaster recovery configuration
Sample disaster recovery configuration for SQL Server with SFW and VVR
Installing SFW with Microsoft clustering
Tasks for installing and configuring SFW with Microsoft clustering
Configuring the storage hardware and network
Campus cluster: Connecting the two nodes
Installing SFW with MSCS/Failover Cluster option
Configuring SFW storage
Tasks for configuring SFW storage
Planning for SFW cluster disk groups and volumes
Sample high-availability cluster storage configuration
Sample campus cluster storage configuration
Sample disaster recovery storage configuration
Considerations when creating disk groups and volumes for a campus cluster
Considerations when creating volumes for a DR configuration using VVR replication
Viewing the available disk storage
Creating dynamic cluster disk groups
Creating dynamic volumes
Managing disk group and volumes
Importing a disk group and mounting a volume
Unmounting a volume and deporting a disk group
Implementing a dynamic mirrored quorum resource
Tasks for implementing a dynamic mirrored quorum resource
Creating a dynamic cluster disk group and a mirrored volume for the quorum resource
Adding a Volume Manager Disk Group resource for the quorum
Adding the quorum resource on Windows Server 2003
Adding the quorum resource on Windows Server 2008
Changing the quorum resource to a dynamic mirrored quorum resource
Changing the quorum to a dynamic mirrored quorum resource on Windows Server 2003
Changing the quorum to a dynamic mirrored quorum resource on Windows Server 2008
Installing SQL Server 2008 and configuring resources
Creating the resource group for the SQL Server instance
Creating the SQL Server resource group on Windows Server 2003
Creating the MSDTC resource (Windows Server 2003)
Creating the SQL Server resource group on Windows Server 2008
Installing SQL Server 2008
Sequence for installing SQL Server 2008 on a Microsoft cluster
Prerequisites for installing SQL Server 2008
Guidelines for installing SQL Server 2008
Dependency graph for SQL Server 2008
Verifying the SQL Server group in the Microsoft cluster
Configuring disaster recovery for SQL Server 2008
Tasks for configuring the secondary site for disaster recovery
Verifying the primary site configuration
Creating a parallel environment on the secondary site
VVR components overview
Setting up security for VVR
Creating resources for VVR
Creating resources for VVR on Windows Server 2003
Creating resources for VVR on Windows Server 2008
Configuring VVR: Setting up an RDS
Creating the RVG resource
Creating an RVG resource on Windows Server 2003
Creating an RVG resource on Windows Server 2008
Setting the SQL server resource dependency on the RVG resource
Working with the solution: Normal operations and recovery procedures
Monitoring the status of the replication
Performing planned migration
Replication recovery procedures
Index

Attachments

SFW_MSCS_SQL2008_Solutions_51SP1.pdf (1.3 MBytes)

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


Terms of use for this information are found in Legal Notices