restored database left in "Loading" status

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

restored database left in "Loading" status

Author

Topic

mike123
Master Smack Fu Yak Hacker

1462 Posts

Posted - 2006-01-17 : 23:35:40

I made a mistake on my database in QA which resulted in me having to restore a 12 hour old backup.

I restored it with force restore over existing database, however the database won't come out of "loading status"

Any idea what the problem could be ? I'm googling now but haven't been able to find exact reason and its sorta urgent as its a live site

thanks for any suggestions or help!
mike123

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2006-01-17 : 23:39:06

Find out if you still have an active process running the restore. If you do, then you can run DBCC OUTPUTBUFFER(SPID#) and see what percent is completed. If it's not still running, then you either lost connection (possibly bad disk or network connection????), have a corrupt database, or another issue that could be about 1000000000000000 things.

What version/service pack are you running? Are there any errors in the error logs (windows or SQL Server)? Do you have that active process? Is the backup stored on tape, remote network share, or local?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

mike123
Master Smack Fu Yak Hacker

1462 Posts

Posted - 2006-01-17 : 23:46:43

Hi derrick,

thanks for the quick response... i killed all the processes with no luck .. before I had a chance to check out your suggestions I actually nuked the database , recreated an empty one and then proceeded to a succesful restore..

not sure what the exact issue was but thanks very much for the tips, Ill be sure to do them next time this happens !