database stuck in loading after displaying restore successful
-
I just restored a database and received a message stating that the database restored successfully. Howevever when I try to view the database it displays database_name (loading). How can I stop this and access the database. Also, why did it tell me it was restored successfully, if it is still loading. Also, I used Enterprise Manager to restore the database and transaction logs to a point in time restore. PLEASE HELP...it's critical that I get it back up. 🙁
-
BO -
RESTORE
NORECOVERY
Instructs the restore operation to not roll back any uncommitted transactions. Either the NORECOVERY or STANDBY option must be specified if another transaction log has to be applied. If neither NORECOVERY, RECOVERY, or STANDBY is specified, RECOVERY is the default.
SQL Server requires that the WITH NORECOVERY option be used on all but the final RESTORE statement when restoring a database backup and multiple transaction logs, or when multiple RESTORE statements are needed (for example, a full database backup followed by a differential database backup).
Note When specifying the NORECOVERY option, the database is not usable in this intermediate, nonrecovered state.
When used with a file or filegroup restore operation, NORECOVERY forces the database to remain in the restoring state after the restore operation. This is useful in either of these situations:
- A restore script is being run and the log is always being applied.
- A sequence of file restores is used and the database is not intended to be usable between two of the restore operations.
You need to restore the last log file and choose from options to leave the DB operational if you do it from EM. If rom TSQL than choose WITH RECOVERY option.
Kindest Regards,Vasc
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply