Hello All !
This is the context (in production):
3 servers for a DB mirroring solution (S1 for "principal", S2 for "mirror", S3 for "Witness"): they run ok (good tests when failovers planned and unplanned)
A DRP log shipping was added for this site: S1 (which is the principal for mirroring) is the "primary" server for log shipping and at the other side S4 is the "standby" and S5 is the "monitor log shipping": ok . Log shipping
had been tested: ok.
But, I have a problem:
When failover occurs on the mirroring : S2 becomes the "principal" but it stops the log shipping, because the log shipping is set to the DB on S1.
So how can i do ? When mirror occurs from S1 to S2, I want log shipping to continue working from S2 and when S1 is coming back, log shipping continue to run.
Is it possible to do that ?
- create a log shipping solution with S2 as "primary" when S2 (secondary) has failover
- disable logshipping jobs on S2 and S4 respectively
When S2 has failovered, S1 will become the principal, all log shipping jobs for S1 runs.
When S1 has failovered, S2 will become the principal, disable all log shippng jobs for S1, enable log shipping job for S2.
Is it possible to do this ? I know that is a bit complex
View Complete Post