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.