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

How to Install SQL Server 2000

previous page next page
How To

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

previous page start next page