dB is Loading

SQL & Win 2K
I have a dB that I restored and it got hung up at a phase
where it is '(Loading)'. I ran the script below, from a
post of Paul's from a while back, and an error message
was returned that 'Database 'xxx' cannot be opened. It is
in the middle of a restore.;' How can I get rid of this
dB?
alter database [xxx] set read_write with rollback
immediate
go
exec sp_removedbreplication [xxx]
go
use master
go
drop database [xxx]
go
TIA,
Larry...
Larry,
as far as I recall, my other solution was for a database stuck in RO mode.
For your case you could try
restore database xxx with recovery
Alternatively, you could restore the most recent backup with norecovery and
the logs with norecovery, apart from the last one which is with recovery.
HTH,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Paul,
I ran the command you suggested and QA returned...
File 'xxx' was only partially restored by a database or
file restore. The entire file must be successfully
restored before applying the log.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Any othere Ideas?
Larry..
|||Larry,
then it looks like your backup file wasn't fully
restored, so try restoring it again using with recovery.
Rgds,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||As always, thanks for your help.