Tasks for recovering a SQL Server database
Prev Recovering a SQL Server database Next

Tasks for recovering a SQL Server database

The following table outlines the high-level objectives and the tasks to complete each objective. The particular task required depends on the type of recovery you are using.

Table: Tasks for recovery using Quick Recovery snapshots

Objective

Tasks

See Prerequisites for recovering a SQL Server database.

  • Verifying the prerequisites for using VSS recovery

See Types of recovery.

  • Understanding the types of recovery

See Recovering using snapshots without log replay.

  • Recovering to a specified point in time using the VSS SQL Restore wizard or the vxsnap utility

See Recovering using snapshots and log replay.

  • Recovering to a point of failure using the SQL Restore wizard or the vxsnap utility

See Restoring snapshots and manually applying logs.

  • Recovering to the time of the snapshot set using the SQL Restore wizard or the vxsnap utility

See Recovering missing volumes.

  • Recovering missing production volumes from snapshot volumes, using the VSS SQL Restore wizard or the vxsnap utility

See Post-recovery steps.

  • Refreshing the snapshot set

  • Performing additional tasks in a Volume Replicator environment
Prev Up Next
About recovering a SQL Server database Home Prerequisites for recovering a SQL Server database