InfoScale™ 9.0 Storage Foundation Quick Recovery Solutions Guide for Microsoft SQL Server - Windows
- Introducing Quick Recovery 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 components used in Quick Recovery
- VCS, Microsoft clustering, and Volume Replicator considerations
- About the Solutions Configuration Center
- Starting the Configuration Center
- Solutions wizard logs
- Preparing to implement Quick Recovery for SQL Server
- Implementing Quick Recovery for SQL Server with the configuration wizard
- About the Quick Recovery Configuration Wizard
- Tasks for implementing snapshot sets with the configuration wizard
- Reviewing the prerequisites
- Scheduling SQL Server snapshot sets
- System Selection panel details
- Instance Selection panel details
- Mount Details panel details
- Synchronizing Schedules panel details
- Template Selection panel details
- Number of Snapshot Sets panel details
- Snapshot Volume Assignment panel details
- Snapshot Schedule panel details
- Specifying snapshot schedule details
- Summary panel details
- Template Implementation panel
- Scheduling or creating an individual snapshot set for SQL Server
- Maintaining or troubleshooting snapshots
- 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
- Post-recovery steps
- Vxsnap restore command reference
- Vxsnap utility command line reference for SQL Server
About the Quick Recovery Configuration Wizard
The Quick Recovery Configuration Wizard provides the most complete method of configuring snapshot sets and is therefore recommended for initial implementation. The Quick Recovery Configuration Wizard enables you to schedule all phases of snapshot creation and maintenance:
Preparing the mirror for the snapshot set.
Creating the initial snapshot set by splitting the mirror so that it is no longer synchronized with the original volume and becomes a point-in-time copy.
Periodically refreshing (resynchronizing) the split-mirror snapshot with the original volume, and then splitting the mirror again.
The wizard enables you to set up and schedule multiple snapshot sets for one or more databases in a SQL Server instance. Each database can have different filegroups, such as Database, Log, and FILESTREAM filegroups.
You can set up one or more schedules for each snapshot set. You can schedule when to prepare the snapshot mirrors, when to create the initial snapshot sets, and when to refresh the snapshot sets, enabling you to establish a schedule that best suits your site. For example, you can schedule mirror preparation, the most time-consuming step, during a time of low activity. The scheduling capability automates the process of refreshing the snapshot sets. At the scheduled times, the snapshot volumes are automatically reattached, resynchronized, and then split again. Once configured and applied, snapshot schedules are maintained by the Veritas Scheduler Service, which runs in the background.
The snapshot creation process integrates with VSS to quiesce the database and then simultaneously snapshot the volumes in the database. The snapshot is done while the database is online and without disrupting the database operations.
The wizard also enables you to save all configuration settings to an XML file that can be imported for use on other systems or instances.
More information is available about the wizard.