Log Shipping Problem/Question.

[kip cavin]

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?

[Greg D. Moore \(Strider\)]

Re: Log Shipping Problem/Question.


"kip cavin" <cavink@sitemas ter.com> wrote in message
news:8323efee.0 409131241.729db 773@posting.goo gle.com...[color=blue]
> 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?[/color]

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.