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