"Sheldon W." <SheldonW@discussions.microsoft.com> wrote in message
news:A38A8B37-C5D4-4157-863D-58BA3230502D@microsoft.com...
>I am running a set of scripts to peform log shipping using a linked servers
> to send a RPC to the standby server sending the log file and path as a
> parameter for a restore command to be on on the stanby server.
>
> For the most part this process runs flawlessly, but when I do have
> problems
> it is usually when the log restore never seems to complete and leaves the
> database in a loading state, so when the following log restore is
> executed,
> it fails due to the state of the database as well as being out of sync.
> Does
> anyone have any idea what would cause relatively small log file restores
> to
> not complete within as much of an hour's time?

"Hilary Cotter" wrote:

> are you restoring over the network? So if your backup or transaction log
> stored locally on the source server?
>
> I have experieinced problems where the restore is aborted and gets caught in
> a rollback which I am unable to complete or kill.
>
> Check using sp_who2 to see if the job is marked rollback
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Sheldon W." <SheldonW@discussions.microsoft.com> wrote in message
> news:A38A8B37-C5D4-4157-863D-58BA3230502D@microsoft.com...
> >I am running a set of scripts to peform log shipping using a linked servers
> > to send a RPC to the standby server sending the log file and path as a
> > parameter for a restore command to be on on the stanby server.
> >
> > For the most part this process runs flawlessly, but when I do have
> > problems
> > it is usually when the log restore never seems to complete and leaves the
> > database in a loading state, so when the following log restore is
> > executed,
> > it fails due to the state of the database as well as being out of sync.
> > Does
> > anyone have any idea what would cause relatively small log file restores
> > to
> > not complete within as much of an hour's time?
>
>