Use the Specify Database State page of the Recovery Wizard to specify the recovery option for recovering the selected SQL Server database. This page contains the following elements. Available options will depend on the selected recovery type.

Elements

Name Description

Leave database operational

Select this option to perform a full recovery and leave the database ready to use.

Leave database non-operational but able to restore additional transaction logs

Select this option to recover the database but leave it non-operational.

Copy SQL transaction logs between the selected recovery point and the latest recovery point

Select this option if you want to copy transaction logs for the database restoring state. This option is disabled if no transaction logs are available for the selected database.

Copy destination

Specify the folder path location to copy SQL Server transaction logs for the database restoring state.

To continue with the recovery, click Next.

See Also