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 elements described in the following table. Available options will depend on the type of data you are recovering.

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.

To proceed with the recovery, click Next.

See Also