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
Reviewing the prerequisites
Before running the Quick Recovery Configuration Wizard, you should do the following:
Ensure that your system hardware and software meets the requirements and review the recommendations and best practices.
Set up SQL Server for use with Storage Foundation (SFW).
See Configuring SQL Server storage with Storage Foundation for Windows.
Ensure that you have disks with enough space to store the snapshot volumes. Each snapshot set requires the same amount of space as the original volumes.
Ensure that you are logged in as a domain administrator or as a member of the Domain Admins group.
If a firewall exists between the wizard and any systems it needs access to, set the firewall to allow both ingoing and outgoing TCP requests on port 7419.
In a clustered server environment, ensure that the scheduler service is configured with domain administrator privileges.
Ensure that the [NT AUTHORITY\SYSTEM] account is granted the sysadmin server role (from SQL Management Studio Console) on each node.
To use a previously created template, copy it to the server that you are configuring.
Ensure that the Microsoft Software Shadow Copy Provider service is running. For a clustered server environment, ensure that the service is running on all systems in the cluster.
Although not required to run the wizard, the SQL Server VSS Writer service must be started for snapshot mirror preparation and scheduled snapshots to occur.