Restore Options
Chapter 4: Restoring Microsoft SQL Server Databases 51
Stop at log mark
The option recovers the database activity through the transaction which is
marked with the specified name, including the transaction that contains the
mark. If you do not select the After Date and Time option, recovery stops at
the first marked transaction with the specified name. If you select the After
Date and Time option, recovery stops at the first marked transaction with
the specified name exactly at or after the specified date and time.
Note:
This option is available in Microsoft SQL Server 2000 and Microsoft
SQL Server 2005 or later.
Stop before log mark
The option recovers the database activity prior to the transaction which is
marked with the specified name. The transaction which contains the mark is
not re-executed. If you do not select the After Date and Time option,
recovery stops at the first marked transaction with the specified name. If you
select the After Date and Time option, recovery stops at the first marked
transaction with the specified name exactly at or after the specified date and
time.
Note:
This option is available in Microsoft SQL Server 2000 and Microsoft
SQL Server 2005 or later.
After Date and Time
Allows you to specify a point in time after which Microsoft SQL Server will
look for the specified Log Mark. The recovery stops at the specified mark only
when the timestamp for the log mark is later than the specified time. The
same Date and Time entry fields are used as for the Stop at Time option. Use
this option with the Stop at Log Mark or Stop Before Log Mark options.
Recovery Completion State Options
The Recovery Completion State options let you specify the final state of a
database after restore. The following options are available:
Leave database operational. No additional transaction logs can be
restored
Instructs the restore operation to roll back any uncommitted transactions.
After the recovery process, the database is ready for use.
Note:
If you use Automatic Selection, you do not have to choose any of the
Recovery Completion State selections manually for each session. CA
ARCserve Backup performs the selection of sessions and applies the
appropriate options automatically to each session. If you do not choose
Automatic Selection, you must follow Microsoft SQL Server rules regarding
the restore flow.
For more information, see Microsoft SQL Server documentation.
