If you restore from a backup with NORECOVERY from the GUI it sometimes doesn't bring the database back online, even if the restore succeeds.
So if you are stuck with a database that no matter how long you give it, the status is restoring, or loading the following command should work:
RESTORE DATABASE databaseName WITH RECOVERY
No comments:
Post a Comment