Types of recovery
The following table gives an overview of the options you can select for recovery. The options are available from either the VSS SQL Restore Wizard or the
vxsnap restore command.
Table: Recovery options
| Selected option | Database state after recovery | Description |
|---|---|---|
| Recovery | online | Restore to the time of the snapshot set. |
| Database and transaction log volumes are restored from the specified snapshot set database and log volumes. No additional transaction logs are applied. | ||
| Recovery, along with the option to restore missing volumes | offline | Restore to the time of the snapshot set. |
| The specified snapshot set volumes are converted from read-only snapshot volumes to read/write volumes. No additional transaction logs are applied. | ||
| You must then manually assign the drive letter/mount path of the missing production volumes to the previous snapshot volumes and bring the database online. | ||
| Recovery + log replay | online | Restore the snapshot set and automatically roll-forward to the point of failure. |
| Restores the database and transaction log volumes from the specified snapshot set and then automatically replays the specified logs to roll forward the recovery to the point of failure. | ||
| Before using this option, you must back up your transaction logs within SQL Server. This log operation requires that at least one Full backup was created earlier. | ||
| No Recovery | loading | Restore the snapshot set and then manually apply logs in SQL. |
| Restores the database and transaction log volumes from the specified snapshot set and leaves the database in a loading state. To bring the database back to an operational state, you must manually apply your backup transaction logs within SQL Server to the desired point in time. | ||
| Before using this option, you must back up your transaction logs within SQL Server. This log operation requires that at least one Full backup was created earlier. |
Related information