Database showing "loading" msg after restore attempt
Posted on 2004-10-15
I am attempting to restore a backup and have completed similar such events numerous times, without issue, across dozens fo SQL servers but now, when I am attempting to restore a backup, either through EM or QA, it seems to complete (and even provides notification that it has completed successfully), but the Database node in EM continues to show a "loading" message - no matter how long I leave it sitting there, it continues to remain inaccessible and show the loading msg - even following severla attempts at restoration.
I am on SQL 2000
the database is set for full recovery and am forcing the restore from a device, with the first recovery completion state option selected (leave database operational)