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
Tasks
How to Recover Data for Desktop ComputersHow to Recover Data for Exchange-Based Servers
How to Recover Data for File Servers
How to Recover Data for SQL Servers
How to Recover Data for Virtual Machines
How to Recover Data for Windows SharePoint Services Servers
How to Recover System State
Concepts
Recovering DataRecovery Wizard