Planning to set up an Always On Availability Group configuration to move data data from a 2012 primary replica into a 2014 “readable” secondary replica? Think it twice!

I had a customer who wanted to use AOAG, not as a HA/DR solution but as one to replicate data to another instance to which they planned to offload all read-only workload. The instance hosting the secondary replica of the database was expected to run a new set of business processes which consumed data from…

0

How is @@DBTS expected to behave on an Always On Availability Group secondary replica, a Database Mirroring mirror, or a database which is being created out of a restored backup and is in standby or in-recovery state?

A coworker recently posted the following to an internal forum: “We are redirecting read load of our SSIS Packages from Primary to Secondary, and our delta logic is dependent of @@dbts values. On primary, the value of @@dbts always changes. But the same on secondary doesn’t change. Any experience around this.” And this is what…

0