You are here

Recovering a database in RESTORING state

When restoring multiple files, your database must be left in a restoring state until the last file is restored.  The database will show "restoring" after the name and is entirely unusable while in that state.  In order to make it usable again, you must either restore the next backup file specifying "WITH RECOVERY", or take it out of the "restoring" state by issuing the following command:

RESTORE DATABASE <database_name> WITH RECOVERY
Categories: 
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
3 + 3 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer