How to recover a database without restoring (Transact-SQL)

How to recover a database without restoring (Transact-SQL)

To recover a database without restoring

• Execute the RESTORE DATABASE statement, specifying:
  • The name of the database to be recovered.
    
    
  • The RECOVERY clause.

Examples

This example recovers the MyNwind database without restoring from a backup.

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

See Also

Recovering a Database Without Restoring

RESTORE