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