I have a single database running on SQL Server 2016 Standard edition in our primary datacenter. I would like to keep a live copy as close to realtime (1-2 minutes) in our disaster recovery datacenter so when the primary goes down we can redirect the traffic to DR. When the primary is back, changes in DR need to sync back to the primary.
From what I've researched peer-peer isn't available in the Standard edition. I found (and lost) a doc that discussed how to do this in Standard edition. It was limited to one database with one primary and one backup, yet I can't figure out what I searched to find it.
Any suggestions on best practice to accomplish this sync?