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!
Here are some notes that should help: Patching Availability Group with One or more Secondary Replicas 1. Change failover mode from Automatic to Manual on all synchronous-commit 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. 2. Make sure Availability Group is on Primary Replica. 3. Upgrade all remote and Secondary Replica. Perform reboot if required. 4. Failover to secondary Replica. 5. Upgrade former Primary replica. 6. Failback Availability Group to Primary replica (secondary replica currently). To manually fail over an availability group, connect to the server instance that hosts the target secondary replica. 7. Set Synchronous commit and Automatic failover as it was before upgrade. While changing back the settings, Availability mode is changed to SYNCHRONOUS_COMMIT, followed by Failover mode to AUTOMATIC.