Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Operations
Administration (Database Engine)
Administration: How-to Topics (Database Engine)
Backing Up and Restoring How-to Topics (Transact-SQL)
How to: Create a Full Database Backup (Transact-SQL)
How to: Use Resource Governor to Limit CPU Usage by Backup Compression (Transact-SQL)
How to: Restore a Database Backup (Transact-SQL)
How to: Restart an Interrupted Restore Operation (Transact-SQL)
How to: Create a Transaction Log Backup (Transact-SQL)
How to: Back Up the Transaction Log When the Database Is Damaged (Transact-SQL)
How to: Apply a Transaction Log Backup (Transact-SQL)
How to: Create a Differential Database Backup (Transact-SQL)
How to: Restore a Differential Database Backup (Transact-SQL)
How to: Recover a Database from a Backup Without Restoring Data (Transact-SQL)
How to: Restore to the Point of Failure (Transact-SQL)
How to: Restore to a Point in Time (Transact-SQL)
How to: Restore the master Database (Transact-SQL)
How to: Back Up Files and Filegroups (Transact-SQL)
How to: Restore Files and Filegroups (Transact-SQL)
How to: Restore Files and Filegroups over Existing Files (Transact-SQL)
How to: Restore Files to a New Location (Transact-SQL)
How to: Restore a Database to a New Location and Name (Transact-SQL)
How to: Enable or Disable Backup Checksums (Transact-SQL)
How to: Specify Whether BACKUP Continues or Stops upon Encountering an Error (Transact-SQL)
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

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

SQL Server 2008 R2

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.

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

Copy 
-- Restore database using WITH RECOVERY.
RESTORE DATABASE AdventureWorks2008R2
   WITH RECOVERY
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.