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
SQL-DMO