August 26, 2016 at 5:47 am
Hello all,
Is it possible to have the same database be part of both an AG AND a mirroring session? We have a scenario where we are considering AG's for servers in the same data center and using mirroring at the same time for the same database but to a replica in a different data center. Has anyone tried something like this? Is it even possible?
Thanks in advance and any help is appreciated.
August 26, 2016 at 5:56 am
why don't you just create another secondary replica to the "other" DC??
August 26, 2016 at 5:56 am
No. Not going to work.
Why not just use another secondary replica in the other data center. You can even make it an async one if you need.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 26, 2016 at 6:58 am
Thanks for the quick responses. The server in the second DC isn't clustered with the first so AG isn't an option. Perhaps we use log shipping to update the second server.
August 26, 2016 at 7:03 am
Log shipping will work. Any reason you can't add the server to the cluster?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 26, 2016 at 7:17 am
My OS team is concerned about latency between the two DC's impacting stability. If you're aware of any supporting documentation I can reference to quell their fears, I'd be much obliged. Again, thanks in advance for this support.
August 26, 2016 at 7:40 am
You can make the secondary replica async if there's a latency concern. You won't be able to auto-failover, but you can't auto-failover with log shipping either.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply