Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.