Monday, March 12, 2012

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 !<csomberg@.dwr.com> wrote in message
news:1115393466.540070.214530@.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

No comments:

Post a Comment