Export (0) Print
Expand All

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

SQL Server 2000

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

Show:
© 2014 Microsoft