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

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


Description



Table of Contents:
Introduction
Introducing Veritas Storage Foundation and High Availability Solutions for Microsoft SQL
About the solutions guides
Quick Recovery
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
Solutions wizard logs
Quick Recovery overview for SQL Server
About Quick Recovery snapshot solutions
About snapshot-assisted backups
Advantages of Quick Recovery snapshots
Quick Recovery process
Methods of implementing Quick Recovery snapshots for SQL Server
About the Quick Recovery Configuration Wizard
About the VSS Snapshot Scheduler Wizard
About the VSS Snapshot and Snapback wizards and the vxsnap utility
About the components used in Quick Recovery
FlashSnap and FastResync
Integration with Microsoft Volume Shadow Copy Service
VSS framework
VSS process
VCS, Microsoft clustering, and VVR considerations
Quick Recovery
Preparing to implement Quick Recovery for SQL Server
Tasks for preparing to implement Quick Recovery for SQL Server
Reviewing the prerequisites
Supported software
Storage requirements and best practices
Configuration requirements and best practices
Reviewing the configuration
Configuring SQL Server storage with Veritas Storage Foundation for Windows
Creating dynamic disk groups
Creating dynamic volumes
Pointing the databases and log paths to the SFW volumes
Implementing Quick Recovery for SQL Server with the configuration wizard
About the Quick Recovery Configuration Wizard
Backup types for snapshot sets
About snapshot templates
Templates and multiple components
Templates and schedule start dates
Tasks for implementing snapshot sets with the configuration wizard
Reviewing the prerequisites
Scheduling and creating snapshot sets
Viewing the status of scheduled snapshots
Troubleshooting scheduled snapshots
Deleting or modifying schedules
Synchronizing schedules after adding a cluster node
Scheduling or creating an individual snapshot set for SQL Server
About scheduling or creating an individual snapshot set
Tasks to schedule a new snapshot set
Tasks to create a one-time snapshot set
Reviewing the prerequisites
Preparing the snapshot mirrors
Scheduling a new snapshot set
Viewing the status of scheduled snapshots
Troubleshooting scheduled snapshots
Deleting or modifying schedules
Creating a one-time snapshot set
Refreshing a snapshot set manually
Reattaching the split-mirror snapshots
Creating the refreshed snapshot set
Recovering a SQL Server database
About recovering a SQL Server database
Tasks for recovering a SQL Server database
Prerequisites for recovering a SQL Server database
Types of recovery
Recovering using snapshots without log replay
Recovering using snapshots and log replay
Restoring snapshots and manually applying logs
Recovering missing volumes
Preparing for the recovery
Reassigning the drive letter or mount points of the missing volumes to the snapshot volumes
Replacing hardware and adding disks to the dynamic disk group
Performing the recovery
Post-recovery steps
Vxsnap restore command reference
Vxsnap utility command line reference for SQL Server
About the Vxsnap utility
Vxsnap keywords
vxsnap prepare
Syntax
Attributes
Example
vxsnap create
Syntax
Attributes
Examples
vxsnap reattach
Syntax
Attributes
Example
vxsnap restore
Syntax
Attributes
Examples
Index

Attachments

SFW_QR_SQL2008_Solutions.pdf (1.1 MBytes)

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


Terms of use for this information are found in Legal Notices