Friday, February 24, 2012

Log Shipping and Backup Log

Hello,
Can anyone tell me whether having your log file back up
affects the Log Shipping in any way ?
Jim
Hi
Yes it does as log shipping relies on dumping and re-applying each log dump
in sequence.
If you need to do an out of sequence dump, run the job created by log
shipping.
What is your scenario?
Regards
Mike
"Jimbo" wrote:

> Hello,
> Can anyone tell me whether having your log file back up
> affects the Log Shipping in any way ?
> Jim
>
|||Thanks for your reply.
As part of our disaster recovery we want a warm standby
machine, with log shipping, from out Production Server to
our Warm Standby server.
We also want to backup the log file from our production
server once every 10 minutes.
I suppose my question is can we do both ?
TIA

>--Original Message--
>Hi
>Yes it does as log shipping relies on dumping and re-
applying each log dump
>in sequence.
>If you need to do an out of sequence dump, run the job
created by log
>shipping.
>What is your scenario?
>Regards
>Mike
>"Jimbo" wrote:
>.
>

No comments:

Post a Comment