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 AdventureWorks database in a restore operation without restoring data.
-- Restore database using WITH RECOVERY.
RESTORE DATABASE AdventureWorks
WITH RECOVERY
See Also
Concepts
Recovering a Database Without Restoring Data
Other Resources
RESTORE (Transact-SQL)
SQL Server Management Studio Tutorial