Types of recovery

The following table gives an overview of the options you can select for recovery. The options are available from either the Enterprise Vault Restore Wizard or the vxsnap restore command.

Table: Recovery options

Selected option

Database state after recovery

Description

Recovery without logs

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.

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.