Restore options
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-
Select this option when restoring the last image in a restore
sequence. After the recovery operation, the database is ready for
use. If recover database is not performed, the database is in an
intermediate state, and is not usable. If is selected when an intermediate
backup is applied, you cannot continue to restore backups; you must
restart the restore operation from the beginning.
|
|
|
|
-
Select the consistency check to be performed after the restore.
Output from the consistency check is written to the SQL Server
client progress log. You cannot select consistency checking unless
the database is restored to the recovered state. If you select
consistency checking for a staged recovery, then the check occurs
following the last restore.
|
|
|
|
-
Exclude indexes from the consistency check. If indexes are not
checked, the consistency check runs significantly faster but is not
as thorough. Only the data pages and clustered index pages for each
user table are included in the consistency check. The consistency
of the non-clustered index pages is not checked.
|
|
|
|
|
|
|
|
-
(SQL Server 2005 or later) These options are available if the
source object was backed up with torn page detection or checksum
verification.
A performance penalty can happen when using page
verification.
|
|
|
|
|
Transaction logs
|
This group contains transaction log recovery options. It is
enabled if you select a transaction log backup image.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-
Specify the time to which you want the transaction
logs restored. These fields are only enabled if you selected one of
the following transaction log recovery options:
|
|
-
This list is enabled if you selected a database
transaction log for restore. The transaction log contains one or
more transaction log marks, and you selected one of the following
transaction log recovery options:
-
To transaction log mark
-
To transaction log mark but after
-
Before transaction log mark
-
Before transaction log mark but after
|
Restore script
|
-
Start the restore operation immediately.
is disabled
if you are logged into a SQL Server instance that is not on the
local host. If you generate a script for a non-local host, it must
be executed on that host.
|
|
|
|
Start the restore or generate a restore script. This is disabled
if you have not selected any objects to restore.
|