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 !

<csomberg (AT) dwr (DOT) com> wrote

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