Specify the options that you want to use when you restore
data from the Recover tab in MMC GUI.
From the
Recover tab, click
Show
Restore Options to change the default restore options.
Click
Hide Restore Options to remove the options
from view.
- AutoSelect
- Set this option to True to
enable auto-selection. With auto-selection, when you select the most
recent backup to restore, all other necessary backups are automatically
selected for you, up to the previous full backup.
When
AutoSelect is
True,
the following behavior occurs:
- 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.
- When you select this option, all databases and storage groups
that are backed up together to the local destination are also automatically
selected. When the backup method is VSS and the destination is local,
this option is supported.
- Stripes
- Under Performance, the number of Stripes is
listed. You can 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 set for SQL buffers. This option is always enabled for
legacy backups. Stripes are not available for VSS backups.
- Database Owner Only
- Under
Restore Behavior, DbOwnerOnly is listed with
a default value of False. You can mark a database
for owner use only by changing this value to True.
The default is not to mark for owner use. This option applies to legacy
restores only.
- Replace
- Under Restore Behavior, Replace is
listed with a default value of False. Change
this value to True if you want to replace a
database during a restore. The default is not to replace databases.
This option applies to legacy restores only.
- Recovery
- Under Restore Behavior, RunRecovery specifies
whether you want more restores to a SQL database that is not on a
standby SQL server.
- Select True when you are making a sequence
of restore operations to an SQL database and the current restore is
the final one in the sequence, or when it is the only restore operation.
- Select False when you are making a sequence
of restore operations to an SQL database and the current restore is
not the final one in the sequence. Select False for
all restore operations in the sequence except for the final one.
The default value is True. During a
restore operation, the operation might fail with a message similar
to the following message:
Failed - An exception occurred while executing a Transact-SQL statement
or batch.
The tail-log backup of the dbName database has not been backed up.
Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you
do not want to lose.
Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to
overwrite the contents of the log.
RESTORE DATABASE is terminating abnormally.
Changed database context to 'master'. (HRESULT:0x80131501)
When
this situation occurs, set the
backup tail of the log option
to
True. After you set this option, select
Log
Backup to TSM to complete the tail-log backup. For information
about tail-log backups, refer to the Microsoft SQL Server documentation.
- Stand By Undo File Name
- Under Restore Behavior, StandByUndoFileName is
listed with a default value of False. Use this
option to specify the undo file path for a legacy restore to a standby
SQL database. It changes the target SQL database in to standby mode.
This
option is available for full, differential, and log backup types for
a database. When you specify this option for a database, it applies
to all backup objects for that database. Likewise, when you remove
this option for a backup object, it is removed for all.
- Source Server
- Under Source Server, FromSQLServer specifies
the name of the SQL server that the backup was created from.
- Change IncludeTsmVM to True to
view Virtual Environment backup SQL databases in the Databases view.
The backup method is listed as TSMVM to distinguish
these databases from the others listed.
- Wait for Tape Mounts for Restore
- Under the Tape section, you
can specify whether the Data Protection for SQL Server restore
operation waits for the Tivoli® Storage Manager server to
mount removable media such as tapes or other sequential device media.
This information is retrieved from Tivoli Storage Manager when
you click the Recover tab, or click the Refresh.
The default value is True.
- Wait for Tape Mounts for File Information
- Under Tape, WaitForTapeMountsForFileInformation is
listed with a default value of True. When querying Tivoli Storage Manager for file
information, you can specify whether Data Protection for SQL Server waits
for the Tivoli Storage Manager server to
mount removable media. This option applies to legacy restores only.
- Instant Restore
- Under VSS, InstantRestore is
listed with a default value of True. You can
disable Instant Restores by setting the value to False,
which bypasses volume-level copy and uses file-level copy to restore
the files from a local VSS backup. If this option is set to True and
if the backup exists on SAN-attached volumes, the volume level snapshot
restore is used for local VSS backups. The default value is to use volume
level snapshot restore if it is supported. This option
is available for VSS operations only. When you are running a VSS instant
restore, ensure that any previous background copies that involve the
volumes that are being restored, are completed before you initiate
the VSS instant restore.
Attention: An instant restore
overwrites all files on the destination file system.