First be patient - I'm an Informix DBA who is tasked to manage a 2005
install. I have a db that's been restoring for 24 hrs and is only 12
MB. Normally it would only take a minutes and it would be done. I've
gone through the logs and found a few errors but nothing to do with
the db in question or the master.

Does anyone have any suggestion on how I can stop this? I can see the
process running but nothing that would indicate anything out of the
norm.

Thanks in advance.

My guess is that you restored the database with the NORECOVERY option so it
is now awaiting transaction log restores. If you don't intend to restoring
log backups, you can immediately recovery the database in question with a
RESTORE...WITH RECOVERY. Note that this does not actually restore the
database since no backup source is specified.

RESTORE DATABASE MyDatabase WITH RECOVERY.

--
Hope this s.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Scott" <scott.cisd@gmail.com> wrote in message
news:93ebd376-ba5b-477d-80b9-daa1a1fabbcf@l42g2000hsc.googlegroups.com...
> First be patient - I'm an Informix DBA who is tasked to manage a 2005
> install. I have a db that's been restoring for 24 hrs and is only 12
> MB. Normally it would only take a minutes and it would be done. I've
> gone through the logs and found a few errors but nothing to do with
> the db in question or the master.
>
> Does anyone have any suggestion on how I can stop this? I can see the
> process running but nothing that would indicate anything out of the
> norm.
>
> Thanks in advance.