<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