July 22, 2018 at 8:41 pm
We had a DR test. We had to failover our AGs to our DR server. We have two replicas for HA which are in synchronous mode. The DR replica is asynchronous.
We did some tests while the DR server was primary. Data was entered.
Then we failed back to the production server.
1. The data that was entered while the DR replica was not found.
2. The failover possibly rolled back all of the databases.
Any tips on failing over to a DR server which is asynchronous without losing data. My initial thought is before failover, make it synchronous.
I appreciate any thoughts and/or feedback.
Thanks.
Things will work out. Get back up, change some parameters and recode.
July 23, 2018 at 1:32 am
Yes, switch it to synchronous mode first and wait for it to sync up.
July 25, 2018 at 2:14 pm
I was gonna say the same thing that Ol Beatrix Kiddo said.
GAJ
Gregory A Jackson MBA, CSM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply