469,949 Members | 2,124 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,949 developers. It's quick & easy.

Help ! Database Still says loading after restore

SQL 2000 SP3

My database is still showing Loading .... after doing a restore and the
restore showing it to be successfull.

I have restarted the service as well.

Help !

Jul 23 '05 #1
1 5007

<cs******@dwr.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
SQL 2000 SP3

My database is still showing Loading .... after doing a restore and the
restore showing it to be successfull.

I have restarted the service as well.

Help !


You don't say what type of RESTORE it was, but if you were restoring a log,
you may have left the database expecting more log restores. If so, you can
try RESTORE MyDB WITH RECOVERY to get it back online.

If that doesn't help, I suggest you give some more information - which MSSQL
version, what type of restore, exactly how you restored it, etc.

Simon
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by great_googley_moogley | last post: by
3 posts views Thread by Jon Jacobs | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.