DB locked up - mid restore

I have just tried to restore an SQL2000 database to a point in time (using
SSMS). It claimed to work successfully, but now the DB is offline, and is
marked as "(loading)".
I cant detach it, restore it, delete it...I can't do anything with it at
all.
Any ideas?
Thanks in advance
ChrisChris,
The last backup you restored did you check on 'Leave database
operational. No additional transaction log can be restored'? If you
missed that one, just restored the last transaction log again with that
option on.
Mel|||"MSLam" <MelodySLam@.googlemail.com> wrote in message
news:1144929164.043122.228370@.e56g2000cwe.googlegroups.com...
> Chris,
> The last backup you restored did you check on 'Leave database
> operational. No additional transaction log can be restored'? If you
> missed that one, just restored the last transaction log again with that
> option on.
>
No I didn't forget...
Nor can I restore again, delete, nor detach...|||... try to restart the MSSQL instance and see if the auto-recovery can
pick the database up. If still cannot, time to do re-create the
database with the latest backup you have.
Mel|||"MSLam" <MelodySLam@.googlemail.com> wrote in message
news:1144943087.458813.10980@.t31g2000cwb.googlegroups.com...
> ... try to restart the MSSQL instance and see if the auto-recovery can
> pick the database up. If still cannot, time to do re-create the
> database with the latest backup you have.
> Mel
>
At one point, the only option I thought I had was to restore from last
nights backup..
However, I eventually managed to release by using 'Restore... With Recovery'
in QA.