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.

To recover a database without restoring

• Execute the RESTORE DATABASE statement, specifying:

  • The name of the database to be recovered.

  • The RECOVERY clause.

Example

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

-- Restore database using WITH RECOVERY.
RESTORE DATABASE AdventureWorks2008R2
   WITH RECOVERY

See Also

Reference

RESTORE (Transact-SQL)

Concepts

Recovering a Database Without Restoring Data

Tutorials