Setting data restore options in Microsoft Management Console

Edit online

To optimize the data restore process for your environment, modify the default options that are available in Microsoft Management Console (MMC).

Procedure
  1. On the Recover tab, select Database Restore.
  2. Click Show Restore Options to modify the default restore options as follows:
    Table 1. Table 1. Database restore options
    OptionAction
    Auto SelectFor this option, specify a value of Yes (default) to quickly select the backup objects to restore. With automatic selection, when you select the most recent backup to restore, all associated backups are automatically selected, up to the previous full backup. When you specify Yes, the automatic selection option applies to full backups, differential backups, and incremental backups, but not to copy backups. This option affects backups in the following ways:
    • When you click a differential backup, the associated full backup is also selected.
    • When you click an incremental backup, the associated full backup and all associated earlier incremental backups are also selected.
    • For VSS backup, automatically selects all databases that were backed up together to the local destination. However, databases that were backed up to IBM Storage Protect are not automatically selected.
    From ServerEnter the name of the server where the original backup is completed. The default value the local server.
    Instant RestoreFor this option, specify a value of Yes to use volume-level snapshot restore (instant restore) for local VSS backups if the backup exists on SAN-attached volumes. Specify a value of No to disable instant restore, which bypasses volume-level copy and uses file-level copy (fast restore) to restore the files from a local VSS backup. The default value is Yes, which uses volume-level snapshot restore if it is available.

    This option is available for VSS operations only. If you use instant restore for SAN Volume Controller earlier than version 5.1 or DS8000®, ensure that any previous background copies that involve the volumes that are being restored are completed before you initiate the instant restore.

    This option is automatically set to No during restore into operations.

    In an instant restore operation, files on the destination file system are overwritten. Incremental and differential backups are automatically converted to file-level restores. An instant restore operation requires that the drive or volume where the mailbox database is located must be available. Any other process or application must not have access to the drive or volume.

    Mount Databases After RestoreFor this option, specify a value of Yes to automatically mount databases after backups are recovered. No is the default value for this option.
    Run Database RecoveryIf more backup files need to be restored before you run database recovery, select False.

    If you want to run database recovery after the restore is done, select True and specify whether only restored logs or both restored and current logs should be used for the recovery.

    • Replay Restored and Current Logs

      Replays all transaction log entries both in the restored log files and in the log files on the server that have not been backed up. You cannot specify this option for instant restore operations.

    • Replay Restored Only

      Replays only restored logs.

    Note: From the MMC, the ERASEexistinglogs parameter can be applied to erase the existing transaction log files for the database that is being restored before you restore it.