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.