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:
    You can modify the default values for the restore options as described in the following table:
    Table 1. Database restore options
    Option Action
    Auto Select For this option, specify a value of Yes 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. This option affects backups in the following ways:
    • When you click a differential backup, the associated full backup is also selected.
    • When you click a log backup, the associated full backup and all associated earlier differential or log backups are also selected.
    Performance
    Stripes For this option, specify the number of data stripes to use in a restore operation. A maximum of 64 data stripes is allowed. The default value is 1.
    The value that you enter must correspond to the value that you set for SQL Server buffers.
    Restriction: This restore option is available only with legacy backups.

    When you use a multiple stripes number for legacy backups, and set the Verify Only parameter to Yes to restore the legacy backup, the number of stripes for legacy restore must be equal to or greater than the number of stripes for the legacy backup.
    Restore Behavior
    Database Owner Only To mark a database for owner use only, set this value to Yes. The default value is No, which specifies not to mark the database for owner use.
    Restriction: This restore option is only available with legacy backups.
    Keep CDC For databases enabled for change data capture (CDC), set this value to Yes to retain, during a legacy restore operation, the change data capture records that have recorded changes, such as insertions, deletions, and edits to SQL Server database tables. The default value is No.
    Restriction: This restore option is only available with legacy backups and applies to all legacy backup types except for log backups.
    Replace To replace a database during a restore operation, set this value to Yes. The default value is No, which specifies not to replace databases.
    Restriction: This restore option is available only with legacy backups.
    Recovery Use this option to restore data to an SQL Server database that is not on a standby SQL Server. The default value is Yes.
    • Select Yes when you run a sequence of restore operations to an SQL Server database and the current restore operation is the final one in the sequence, or when it is the only restore operation.
    • Select No when you run a sequence of restore operations to an SQL Server database and the current restore operation is not the final one in the sequence. Select No for all restore operations in the sequence except for the final one.
    Stand By Undo File Name For this option, specify a value of Yes to change the target SQL Server database to a standby SQL Server database. The default value is No.

    This option is available for full, differential, and log backup types. When you specify this option for a database, it applies to all backup objects for that database. Similarly, when you remove this option for a backup object, the option is removed for all backup objects.
    Verify Only Before you restore a legacy database backup, set this option to Yes to verify that the database backup is complete and can be read. The default value is No.
    Note: This option only verifies that the database backup volumes are complete and that all are readable. It does not save the backup to disk or overwrite the current database of that name on the SQL server.
    To verify a backup done with multiple stripes, set the Verify Only parameter to Yes and ensure that the number of stripes used for the restore is equal to the number of stripes used for the backup.
    Restriction: This restore option is available only for legacy database backups.
    Source Server
    From SQL Server Use this option to specify the name of the SQL Server that the backup is created from.

    To specify the name of a virtual environment SQL Server, change IncludeTsmVM to Yes to view Virtual Environment backup SQL Server databases in the Databases view. The backup method is listed as TSMVM to distinguish these databases from the other databases that are listed.

    Tape
    Wait for Tape Mounts for Restore Use this option to specify whether the Data Protection for SQL Server restore operation waits for the IBM Storage® Protect server to mount removable media such as tapes or other sequential device media. The default value is Yes.
    Wait for Tape Mounts for File Information When you query IBM Storage Protect for file information, use this option to specify whether Data Protection for SQL Server waits for the IBM Storage Protect server to mount removable media. The default value is Yes.
    Restriction: This restore option is available only with legacy backups.
    VSS
    Instant Restore For 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.

    In an instant restore operation, files on the destination file system are overwritten. Log 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.