DescriptionOption
This option is only available for database objects.
Specifies the exact time when the rollforward of transactions will be
stopped. Therefore, to enable database recovery to a particular
point in time, backup you restore from must be a transaction log
backup.
You cannot use this option with NORECOVERY or STANDBY. If you
specify Stop at time that is after the end of RESTORE LOG operation,
the database is left in a non-recovered state (as if RESTORE LOG is
run with NORECOVERY).
Stop at
If you restored a database version and left it in a non-operational
or standby state, you can subsequently restore differential or
transaction log backups one by one, leaving each version
non-operational to restore additional backups.
Restore only this
backup
All necessary versions are restored, including the latest full backup,
the latest differential backup (if one exists), and all transaction log
backups from the last differential up to the selected version.
Full restore of the
database
Overwrites the existing database residing on the target SQL Server
instance.
If a database with the same name as the one you are restoring
already exists and has a different internal structure, SQL Server does
not let you rewrite the database unless you select this option.
If you are restoring a data file from the PRIMARY group to an existing
database, you must set this option for that data file.
Force restore over
the existing database
Enables selecting the database state after recovery. You may select
from:
• Leaving the database operational. Once the last transaction log
is restored and the recovery completed, the database becomes
operational.
• Leaving the database non-operational after the last transaction
log is restored. You may restore additional transaction logs one
by one.
• Leaving the database in read-only mode. You may restore
additional transaction logs before the database is set to read-write
mode.
This selection is only available for database objects.
Recovery completion
state
Data Protector Microsoft SQL Server ZDB integration272
To Next Page
Loading...
