Veritas Cluster Server 5.1 SP1 Implementation Guide for Microsoft SQL 2008 - Windows

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


Description



Table of Contents:
Introducing the VCS agents for SQL Server 2008 and NetApp
About the VCS agents for SQL and NetApp
About VCS hardware replication agent for NetApp
About the NetApp Filer agent
Resource type definition for NetApp Filer agent
Attribute definitions for NetApp Filer agent
About the NetApp SnapDrive agent
Resource type definition for NetApp SnapDrive agent
Attribute definitions for NetApp SnapDrive agent
About the NetApp SnapMirror agent
Action function
Resource type definition for NetApp SnapMirror agent
Attribute definitions for NetApp SnapMirror agent
About the VCS database agent for Microsoft SQL Server 2008
About the agent for SQL Server 2008 Database Engine
Resource type definition for SQL Server 2008 Database Engine agent
Attribute definitions for SQL Server 2008 Database Engine agent
About the agent for SQL Server 2008 FILESTREAM
Resource type definition the SQL Server 2008 FILESTREAM agent
Attribute definitions the SQL Server 2008 FILESTREAM agent
About the GenericService agent for SQL Server 2008 Agent and Analysis services
About the agent for SQL Server 2008 MSDTC service
Resource type definition for SQL Server 2008 MSDTC agent
Attribute definitions for SQL Server 2008 MSDTC agent
SQL Server 2008 sample dependency graph
MSDTC sample dependency graph
Database monitoring options
How the agents make SQL Server highly available
Local cluster configuration
Disaster recovery configuration
Running SQL Server in an Active-Active clustered environment
Typical SQL Server 2008 configuration in a VCS cluster
Typical disaster recovery configuration
Installing the VCS database agent for SQL Server 2008
About installing the VCS agent for SQL
Before installing the SQL Server agent
Installing the SQL Server agent
Configuring the cluster
Configuring Web console
Configuring notification
Configuring Wide-Area Connector process for global clusters
Installing and configuring SQL Server 2008
About installing and configuring SQL
Before installing SQL Server 2008
Privileges requirements
Configuring Microsoft iSCSI Initiator
Managing storage using Network Appliance Filer
Connecting virtual disks to the cluster node
Disconnecting virtual disks from the cluster nodes
Managing storage using Windows Logical Disk Manager
About LDM support
Reserving disks (if you use Windows LDM)
Creating volumes (if you use Windows LDM)
Mounting volumes (if you use Windows LDM)
Unassigning a drive letter
Releasing disks (if you use Windows LDM)
Installing and configuring SQL Server 2008 on the first cluster node
Installing and configuring SQL Server 2008 on the additional cluster nodes
Assigning ports for multiple SQL Server instances
Configuring the SQL service group
About configuring the SQL service group
Before configuring the SQL service group
Configuring a SQL Server 2008 service group
Running SnapManager for SQL
Creating a SQL Server user-defined database
Adding storage agent resources to the SQL service group
Verifying the service group configuration
Bringing the service group online
Taking the service group offline
Switching the service group
Administering a SQL Server service group
Modifying a SQL service group configuration
Deleting a SQL service group
Configuring an MSDTC service group for high availability
About configuring the MSDTC service group
Before configuring the MSDTC service group
Reviewing the configuration
Creating an MSDTC Server service group
About configuring the MSDTC client
Configuring MSDTC client on Windows 2003
About using the virtual MMC viewer
Viewing DTC transaction information
Verifying the installation
Making a standalone SQL Server highly available
About making a standalone SQL Server 2008 highly available
Reviewing the configuration
Sample configuration
Install and configure VCS on the standalone SQL Server 2008
Verify that SQL Server 2008 databases and logs are moved to shared storage
Install and configure SQL Server on additional nodes
Assign ports for multiple SQL Server instances
Configure the VCS SQL server service group
Create a SQL Server 2008 user-defined database
Verify the configuration
Active-Active configuration
About active-active configuration
Reviewing the configuration
Sample configuration
Installing VCS and configuring the cluster
Configure volumes or virtual disks for SQL server
Installing and configuring the first instance of SQL Server
Configuring the VCS service group for the first SQL Server instance
Creating a SQL Server user-defined database
Repeating SQL Server installation for additional instances
Verify the Active-Active configuration
Disaster recovery configuration
About disaster recovery configuration
What is a disaster recovery solution?
Why implement a disaster recovery solution?
Understanding replication
What needs to be protected in a SQL Server environment?
Typical disaster recovery configuration
Disaster recovery: New SQL Server 2008 installation
Reviewing the configuration
Installing VCS and configuring the cluster
Configuring volumes or LUNs on the shared storage
Installing and configuring SQL Server 2008 at the primary site
Configuring the VCS SQL service group
Create a parallel environment on the secondary site
Configuring DR components
Configuring replication using NetApp SnapMirror
Configure SnapMirror resource in the SQL service group
Configure Global Cluster Option for wide-area failover
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
Administering global service groups
Taking a remote global service group offline
Switching a remote service group
Deleting a remote cluster
Removing VCS agents for SQL Server
Prerequisites for removing VCS agents
Uninstalling the agents
Troubleshooting the agents
About troubleshooting VCS agents
VCS logging
VCS Cluster Configuration Wizard logs
VCWsilent logs
Network Appliance agents error messages
SQL agent error messages and descriptions
Agent for MSDTC
Agent for SQL Server 2008
Agent for SQL Server 2008 FILESTREAM

Attachments

VCS_NetApp_SQL2008_51SP1.pdf (1.2 MBytes)

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


Terms of use for this information are found in Legal Notices