Setting data restore options

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

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.

   Option	Action
   Auto Select	Specify a value of Yes (default) to 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	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 buffers. Restriction: This restore option is available only with legacy backups. When you use multiple stripes for legacy backups, with the Verify Only parameter set to Yes, the number of stripes for legacy restore must be equal to or greater than the number of stripes for that backup.
   Restore Behavior
   Database Owner Only	To mark a database for owner use only, set this value to Yes. The default value is No, specifying 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 with recorded changes. These changes are 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 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 database and the current restore operation is the final one in the sequence. Alternatively, use this option when it is the only restore operation. Select No when you run a sequence of restore operations to an SQL 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 database to a standby SQL 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 volumes are complete and that all can be read. The default value is No. Note: This option verifies only that the database backup volumes are complete and that they are readable. It does not verify the structure of the data that is contained in the backup volumes. When you use multiple stripes for legacy backups, with this option set to Yes for legacy backups, the number of stripes for the restore must be equal to or greater than the number of stripes for that 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 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 IBM Storage Protect Snapshot for Exchange 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 if IBM Storage Protect Snapshot for Exchange Server waits for the IBM Storage Protect server to mount removable media. The default value is Yes. Restriction: You can use this restore option only with legacy backups.
   VSS
   Instant Restore	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. Instant restore for SAN Volume Controller earlier than Version 5.1 or DS8000®, you must ensure that previous background copies that involve volumes that are being restored are completed first. 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.