How to get log shipping to work with log backups?

How exactly are you supposed to get log shipping to work
with log backups? I have the production server which
backups up logs every two hours on the hour. I have
another server which I am log shipping to. I set it up to
log ship every 55 minutes. The second time around it
failed. I don't get it how are you supposed to set this up.
?
I'm not too sure what error you received but this should work OK. Try
manually restoring the logs and then adjust the copy and load frequencies to
be every 15 minutes. This will definitely avoid any issues with backlogs. If
this doesn't work then something else is wrong in the setup and in this case
please post up any error messages , info from the monitor, info about whick
logs have been copied over etc.
Regards,
Paul Ibison
|||It says that the log sequence number is not in synch that
it needs an earlier transaction log. When I copy over the
backup of the transaction log that was made from the other
maintenance plan for transaction logs I was able to apply
it no problem.
I just want to get rid of the other maintence plan
altoghter. What I am worried about is will log shipping
truncate the log when it's done. I don't want the
transaction log to grow indefinitely.
Or if I am totally wrong in my thinking here please advise.
Thanks,
Bryan
>--Original Message--
>I'm not too sure what error you received but this should
work OK. Try
>manually restoring the logs and then adjust the copy and
load frequencies to
>be every 15 minutes. This will definitely avoid any
issues with backlogs. If
>this doesn't work then something else is wrong in the
setup and in this case
>please post up any error messages , info from the
monitor, info about whick
>logs have been copied over etc.
>Regards,
>Paul Ibison
>
>.
>
|||Bryan,
backup of the log truncates it unless NO TRUNCATE is specified, and this is
not the default on log shipping, so Yes, it will truncate. Having 2
maintenance plans to backup the logs, one of which is used for log shipping
is not something I've ever tested, but logically it looks sure to fail due
to non-contiguous LSNs. In your case I'd remove both plans, and recreate the
log-shipping one.
HTH,
Paul Ibison