July 17, 2002 at 4:16 pm
At 2pm today I tried to restore one of my databases. I doubt its even a gig in size - I use veritas as the backup program. Anyway, I got a message from veritas that the restore was successful. Sql Server has in its log that the restore was successful. But when I try to go into my databases - it says 'databasename (loading)'. Its been 3 hours. Can anyone tell me if thats normal - or is something wrong? Thanks so much!!!
July 17, 2002 at 8:40 pm
This has been discussed in a few threads but them seemed to help most. Check out http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3538&FORUM_ID=5&CAT_ID=1&Topic_Title=Restored%20db%20still%20shows%20as
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 18, 2002 at 8:10 am
I read the thread and tried some of their suggestions. sp_who2 does not indicate any connections to that DB, but I can't detach b/c it says it is in the middle of a restore. sp_helpdb does not list it in the DB catalogue - however there is a .mdf file for it (I did a search). I tried stopping and starting services, and that didn't change the (loading) status of the DB.
Is there anything else I can do to try and get this database restored? Any help is GREATLY appreciated!!
Edited by - rachel on 07/18/2002 08:12:07 AM
July 18, 2002 at 9:48 am
This happened to me once. I got the solution here (as always) Where? Sorry, mi memory has been taking a nap since Woodstock!!
Anyway, What I got from here was: Detach the database in question and reattach. Stop and restart SQL Server. That did the trick. The cause of this was the SQL Agent was hagging at the same time (eventhough, it appears to be on) Good Luck!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply