How to test DR procedure on actual environment? Is it acceptable to test this on actual environment or peoples use different technique to test this?
SQL 2012 AlwasysOn WSFC Availability Group (No FCI configured)
All nodes are standalone instance.
Primary Site- 2 Node running in synchronized mode with auto fail-over.
DR Site- 1 Node running in A-synchronized mode with manual fail-over.
If you've never done this before, start with small steps. First check if your environment is AlwaysOn aware. Some things to check: listener process running? Logins and Jobs on all nodes? Jobs on secondary nodes are AlwaysOn aware?
The next step is to do a failover outside office hours to the other node on the primary site to make you comfortable with this action. Make sure you have some people working with the application during the failover, so you can collect the behavior of the application during a failover. Also check if you SQLjobs are working properly and logins are
The next step is to know how to restore a database in an AlwaysOn environment. Remember: AlwaysOn doesn't prevent you from user errors like deleting too much data.
Hope this helps you starting working with AlwaysOn!
answered Nov 29, 2015 at 11:53 AM
Wilfred van Dijk
Here are some notes that should help:
Patching Availability Group with One or more Secondary Replicas
Also change Availability mode from Synchronous-commit to Asynchronous-commit. Failover mode needs to be changed first to Manual before the Availability mode is changed to ASYNCHRONOUS_COMMIT.
While changing back the settings, Availability mode is changed to SYNCHRONOUS_COMMIT, followed by Failover mode to AUTOMATIC.
answered Jul 26, 2016 at 05:00 AM