Export (0) Print
Expand All
2 out of 3 rated this helpful - Rate this topic

How to: Recover a Database from a Backup Without Restoring Data (Transact-SQL)

This topic explains how to recover a database in a restore operation without restoring data.

  1. Execute the RESTORE DATABASE statement, specifying:

    • The name of the database to be recovered.
    • The RECOVERY clause.

This example recovers the AdventureWorks database in a restore operation without restoring data.

-- Restore database using WITH RECOVERY.
RESTORE DATABASE AdventureWorks
   WITH RECOVERY
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.