Veritas Cluster Server One 5.0 Service Pack 2 Agent for Microsoft SQL Configuration Guide

Article:DOC3801  |  Created: 2011-03-17  |  Updated: 2011-03-17  |  Article URL http://www.symantec.com/docs/DOC3801
Article Type
Documentation


Subject

Description



Table of Contents:
Introducing the VCS One agents for SQL Server
About the VCS One agents for Microsoft SQL Server
About the agent for SQL Server Database Engine
Attribute definitions for SQL Server Database Engine agent
About the GenericService agent for SQL Server services
Attribute definitions for GenericService agent
About the agent for FileStream
Attribute definitions for FileStream agent
About 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
SQL Server failover service group- resource dependency graph
SQL Server standalone (start/stop) service group- resource dependency graph
Typical SQL Server configuration in a VCS One cluster
Installing, modifying and removing the VCS One database agent for SQL Server
Before installing the agent
Installing the agent
Adding the agent resource type to the Policy Master Server- Using CLI
Importing the Binary Message Catalog (BMC) files
Modifying or removing the agent installation
Uninstalling the agent pack
Installing and configuring SQL Server
About installing and configuring SQL Server
Supported software
Before installing SQL Server
About managing storage
About managing storage using Windows Logical Disk Management (LDM)
About managing storage using SFW
Unmounting the volumes
Installing SQL Server
Installing SQL Server on the first cluster system
Installing SQL Server on the failover cluster systems
Changing the default datapath to the shared drive in case of SQL 2005
Changing the default datapath to the shared drive in case of SQL 2008
Assigning ports for multiple SQL Server instances
Configuring the SQL service group
About configuring the failover SQL Server service group
About configuring the start/stop SQL Server service group
Before you configure a SQL Server service group
Creating a SQL Server service group using the wizard
Making an existing SQL Server highly available
About making existing SQL server highly available
Reviewing the configuration
Before you begin to install VCS One
Configuring the storage, hardware and network
Converting the existing SQL server into a clustered server
Moving the existing SQL Server data files and user databases
Administering the service group
Modifying the SQL Server service group
Prerequisites
Modifying a SQL Server service group
Creating a SQL Server user-defined database
Adding storage agent resources to the SQL service group
Upgrading SQL Server
About upgrading SQL Server
Upgrading from Microsoft SQL Server 2005 to SQL Server 2008
Upgrading SQL on the first cluster system
Upgrading SQL Server on the failover systems
Upgrading the SQL Server service packs
Upgrading SQL Server 2005 to SQL Server 2005 SP1
Upgrading SQL Server 2005 to 2005 SP2 or later
Prerequisites
Preliminary installation information
Installing the Service Pack on passive cluster systems
Installing the Service Pack on active cluster systems
Upgrading Microsoft SQL Server 2008 to 2008 SP1
Prerequisites
Upgrading the cluster
Resource type definitions
About resource type definitions
Agent for SQL Server
Resource type definition
Agent for SQL Server FileStream
Resource type definition
Troubleshooting VCS One agents
About troubleshooting the VCS One database agent for SQL
Newly added SQL Server 2008 Databases are not accessible on failover
SQL Server service group faults upon a failover with an error - Failed to find Disk Group
Error messages and descriptions
VCS One logging

Attachments

Veritas Cluster Server One 5.0 Service Pack 2 Agent for Microsoft SQL Configuration Guide
vcsone_win_sqlagent_50sp2.pdf (760 kBytes)

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


Terms of use for this information are found in Legal Notices