Methods of implementing Quick Recovery snapshots for SQL Server
Storage Foundation for Windows provides more than one method of implementing Quick Recovery snapshots for SQL Server.
-
Quick Recovery Configuration Wizard
-
VSS Snapshot Scheduler
-
VSS Snapshot and Snapback wizards and the vxsnap utility
The following table summarizes the methods and when you would use them.
Table: Methods of implementing Quick Recovery snapshots
| Tasks | Method | For more information |
|---|---|---|
| - Set up and schedule multiple snapshot sets for multiple databases or | From the Solutions Configuration Center\: | See About the Quick Recovery Configuration Wizard . |
| - Perform major updates to an existing snapshot set schedule | Quick Recovery Configuration Wizard | |
| - Add a new snapshot set schedule for one database | From the VEA\: | See About the VSS Snapshot Scheduler Wizard . |
| VSS Snapshot Scheduler Wizard | ||
| You can also use the Quick Recovery Configuration Wizard. | ||
| - Create a one-time snapshot as needed | From the VEA\: | See About the VSS Snapshot and Snapback wizards and the vxsnap utility . |
| VSS SQL Snapshot Wizard and VSS Snapback Wizard | ||
| You can also use the Vxsnap utility from the CLI. |