Export (0) Print
Expand All

Recovering a Database Without Restoring

SQL Server 2000

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

Transact-SQL

SQL-DMO

Show:
© 2014 Microsoft