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

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


Description



Table of Contents:
About the VCS agents for SQL and NetApp
About the VCS hardware replication agent for Network Appliance
About the NetApp Filer agent
About the NetApp SnapDrive agent
About the NetApp SnapMirror agent
About the VCS database agent for Microsoft SQL Server
Agents for SQL Server 2000 overview
Agents for SQL Server 2005 overview
About the SQL Server 2000 agents
Agent for SQL Server 2000 overview
Agent for MSSearch service overview
About the SQL Server 2005 agents
Agent for SQL Server 2005 overview
Agent for SQL Server 2005 Agent service overview
Agent for SQL Server 2005 Analysis service overview
About the agent for MSDTC service
About SQL Server services
MSSearch service
Microsoft Data Transaction Coordinator (MSDTC) service
Monitoring options
How the agents make SQL Server highly available
Local cluster configuration after a failover
Disaster recovery configuration after a failover
Running SQL Server in an active-active clustered environment
Typical SQL Server 2000 configuration in a VCS cluster
Typical SQL Server 2005 configuration in a VCS cluster
Typical disaster recovery configuration of a VCS cluster
About installing the VCS agent for SQL
Before installing the VCS agent for SQL
Installing the VCS agent for SQL
Configuring the cluster
Configuring Web console
Configuring notification
Configuring Wide-Area Connector process for global clusters
About installing and configuring SQL
Prerequisites for installing SQL
Privileges requirements for installing SQL
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 SQL Server 2000 on the first node
Preparing to install SQL Server 2000 on the second node
Stopping the SQL Server 2000 Service
Disconnecting virtual disks from the first node to prepare for SQL Server 2000
Releasing disks from the first node (if you use Windows LDM) to prepare for SQL Server 2000
Connecting virtual disks to the second node to prepare for SQL Server 2000
Mounting volumes on the second node (if you use Windows LDM) to prepare for SQL Server 2000
Renaming shared SQL Server 2000 files to prepare for SQL Server 2000
Installing SQL Server 2000 on the second node
Installing SQL Server
Setting the clustered instance internal name
Installing SQL Server 2005 on the first node
Preparing to install SQL Server 2005 on the second node
Stopping the SQL Server 2005 service
Disconnecting virtual disks from the first node to prepare for SQL Server 2005
Releasing disks from the first node (if you use Windows LDM) to prepare for SQL Server 2005
Connecting virtual disks to the second node to prepare for SQL Server 2005
Mounting volumes on the second node (if you use Windows LDM) to prepare for SQL Server 2005
Renaming shared SQL Server 2005 files to prepare for SQL Server 2005
Installing SQL Server 2005 on the second node
Removing shared SQL Server 2005 files
Assigning ports for multiple SQL Server instances
About configuring the SQL service group
Before configuring the SQL service group
Configuring a SQL Server service group
Running SnapManager for SQL
Creating a SQL Server user-defined database
Creating new volumes or LUNs
Creating a new SQL Server 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
About configuring the MSDTC service group
Before configuring the MSDTC service group
Reviewing the configuration
Creating an MSDTC service group
About configuring an MSDTC client
Configuring an MSDTC client on Windows Server 2003
Configuring an MSDTC client on Windows Server 2008
Verifying the installation
About making a standalone SQL server highly available
Reviewing the configuration
Sample configuration
Configuring the storage hardware and network
Preparing the standalone SQL Server
Backing up existing SQL data
Setting SQL Server services to manual start
Installing and configuring VCS on the standalone SQL server
Installing and configuring SQL Server on additional nodes
Moving the existing SQL Server data files and user databases
Configuring the VCS SQL Server service group
Creating a SQL Server user-defined database
Verifying the installation
About active-active configuration
Reviewing the configuration
Sample configuration
Configuring the storage hardware and network
Installing VCS and configuring the cluster
Configuring 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
Verifying the 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 2000 installation
Reviewing the configuration for SQL Server 2000
Installing VCS and configuring the cluster for SQL Server 2000
Configuring volumes or LUNs on the shared storage for SQL Server 2000
Installing and configuring SQL Server 2000 at the primary site
Configuring the VCS SQL Server 2000 service group
Creating a parallel environment on the secondary site for SQL Server 2000
Disaster recovery: New SQL Server 2005 installation
Reviewing the configuration for SQL Server 2005
Installing VCS and configuring the cluster for SQL Server 2005
Configuring volumes or LUNs on the shared storage for SQL Server 2005
Installing and configuring SQL Server 2005 at the primary site
Configuring the VCS SQL Server 2005 service group
Creating a parallel environment on the secondary site for SQL Server 2005
Configuring DR components
Configuring replication using Network Appliance SnapMirror
Configuring SnapMirror resources at the primary site
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
Administering global service groups
Deleting a remote cluster
About removing VCS
Prerequisites for removing VCS
Removing the VCS configuration
Uninstalling the agents
Prerequisites for uninstalling the agents
Removing VCS
Adding or removing license keys
About troubleshooting VCS agents for Network Appliance and Microsoft SQL Server
VCS logging
VCS Cluster Configuration Wizard (VCW) logs
VCWsilent logs
Network Appliance agents error messages
Error messages and descriptions
Agent for SQL Server 2000 error messages
Agent for MSSearch error messages
Agent for MSDTC error messages
Agent for SQL Server 2005 error messages
Agent for SQL Server 2005 Agent service error messages
Agent for SQL Server 2005 Analysis service error messages
About resource type definitions of agents
NetApp Filer agent
NetAppFiler agent resource type definition
NetAppFiler agent attribute definitions
NetApp SnapDrive agent
NetAppSnapDrive agent resource type definition
NetAppSnapDrive agent attribute definitions
NetApp SnapMirror agent
NetAppSnapMirror agent resource type definition
NetAppSnapMirror agent attribute definitions
Agent for SQL Server 2000 definitions
Resource type definition for SQLServer2000
Attribute definitions for a SQLServer2000 resource type
Sample dependency graph for SQL Server 2000 service group
Agent for MSSearch service definitions
Resource type definition for MSSearch
Attribute definitions for an MSSearch resource type
Sample dependency graph for MSSearch service
Agent for SQL Server 2005 definitions
Resource type definition for SQLServer2005
Attribute definitions for a SQLServer2005 resource type
Sample dependency graph for SQL Server 2005
Agent for SQL Server 2005 Agent service definitions
Resource type definition for SQLAgService2005
Attribute definitions for a SQLAgService2005 resource type
Sample dependency graph for SQL Server 2005 Agent service
Agent for SQL Server 2005 Analysis service definitions
Resource type definition for SQLOlapService2005
Attribute definitions for a SQLOlapService2005 resource type
Sample dependency graph for SQL Server 2005 Analysis service
MSDTC agent definitions
Resource type definition for MSDTC
Attribute definitions for an MSDTC resource type
Sample dependency graph for MSDTC service group
About using the virtual MMC viewer
Viewing DTC transaction information
About sample configurations for SQL Server 2000 and SQL Server 2005
Sample configuration for a SQL Server 2000 cluster
Sample configuration for a SQL Server 2005 cluster

Attachments

VCS_NetApp-SQL_51SP1.pdf (3 MBytes)

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


Terms of use for this information are found in Legal Notices