I have two SharePoint farms, an active and a DR farm, using SQL Availability groups to sync content and some service DBs. In the event of a manual failover, how do I prevent the primary farm from trying to write anything to the now-active databases that are now being used by the DR farm?
More details: I have a three node AOAG, nodes A and B are in the main site and are in sync mode, node C is in the DR site and is an async node. The primary farm was configured with the listener name, so sync-failovers are working perfectly between the sync nodes A and B. The DR farm is configured with a local SQL alias to the read-only async node, so the DR farm will never try to write anything directly to the SQL databases in the main site. After a failover, Node C becomes read-write, and so the DR farm is then in read-write mode, which is great. But how do I prevent the Main farm from trying to write anything to the now active node C?