The Recovery State tab of the Restore wizard allows you to choose the recovery state each database should be left in after the restore.
Fully accessible is the only recovery state supported by the InstantRestore feature. If you choose a partial recovery state, you cannot restore your database using InstantRestore. For additional information about performing an InstantRestore, see how InstantRestore works .
Which recovery states are supported?
SQL Safe supports the following recovery states:
- Fully Accessible. Leaves the database operational. No additional transaction logs can be restored. Note that you must use this fully operational recovery state to use InstantRestore.
- Not Accessible (no recovery mode). Leaves the database non-operational, but able to restore additional transaction logs.
- Accessible but read-only (standby mode). Leaves the database read-only and can restore additional transaction logs. You can specify an Undo file for this option.
Click on Apply to All if you want to apply the same settings set for one database to all databases in the list.
Once you select the recovery state, click NEXT to select the restore type.