Log Shipping Problem/Question.

It seems that my warm standby database is locked up in status
(Loading). The Standby server locked up over the weekend and now the
database was left in (Loading) Status.

If I try to right click on the database in enterprise manager and do a
properties I get the following error message:

"Error 927: Database 'db name' cannot be opened. It is in the middle
of a restore."

Is there some way to abort the current restore process and re-start
the log shipping process?"kip cavin" <cavink@.sitemaster.com> wrote in message
news:8323efee.0409131241.729db773@.posting.google.c om...
> It seems that my warm standby database is locked up in status
> (Loading). The Standby server locked up over the weekend and now the
> database was left in (Loading) Status.
> If I try to right click on the database in enterprise manager and do a
> properties I get the following error message:
> "Error 927: Database 'db name' cannot be opened. It is in the middle
> of a restore."
> Is there some way to abort the current restore process and re-start
> the log shipping process?

You can try a RESTORE DATABASE 'db name' with recovery

That may get it back into a usuable state.

(You might also try RESTORE LOG from disk ='applicable log file' with
standby='c:\foo.log' This should try to restore the log and put the DB in
read-only mode, but allow you to restore subsequent logs w/o an issue.sql