Recovering a Database Without Restoring

Administering SQL Server

Administering SQL Server

Recovering a Database Without Restoring

Usually, you recover the database when you restore the last backup. It is also possible to recover the database without restoring a backup. This is necessary if:

  • You did not recover the database as part of the last restore, but you now want to use the database.

  • Your database is in standby mode, and you want to make it updatable without applying another log backup.

To recover a database without restoring