 | ||
| About the Quick Recovery Configuration Wizard | ||
|---|---|---|
| Prev | Implementing Quick Recovery for SQL Server with the configuration wizard | Next |
| ||
| About the Quick Recovery Configuration Wizard | ||
|---|---|---|
| Prev | Implementing Quick Recovery for SQL Server with the configuration wizard | Next |
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 as follows:
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, for a time of low activity. The scheduling capability automates the process of refreshing the snapshot sets. At the time scheduled for the snapshot, the snapshot volumes are automatically reattached, resynchronized, and then split again.
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.
Once configured and applied, snapshot schedules are maintained by the Veritas Scheduler Service, which runs in the background.
The wizard includes the following settings:
Which database to snapshot
Number of snapshot sets for each database
Volume layout and disk location for each snapshot set
When to prepare the selected volumes for the snapshots
When and how often snapshots occur
You can schedule snapshot run days using days of the week, days of the month, and include or exclude dates. You can specify that a schedule recurs daily or uses some other recurrence interval. You can also schedule a daily time window in which the snapshots occur, and the intervals for refreshing snapshot sets within the time window.
Backup type (Copy or Full)
Optionally, you can also specify scripts to run before and after snapshots.
After you configure the settings, you can do one or both of the following:
Save the settings in a template file for reuse on other systems or instances. Even if you do not save the settings to a template file, they are still stored for the databases to which they apply. You can access them later by selecting the same instance and database in the wizard.
Implement the settings immediately.