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 able to restore additional transaction logs. You can specify an Undo file for this option.
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >
  • No labels