Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Recovering a Database Without Restoring

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:
© 2015 Microsoft