- Remove the sandbox from the availability group:
- Delete the Sandbox from the replicant SQL Server (SQLServer2 in the case)
- Create a new backup of the Primary Database, checking “Copy-only Backup”
- Doesn’t matter where you place this backup, but ‘C:\SQLClusterTemp’ is as good a place as any:
- Restore the primary data into the Sandbox as normal (Don't forget to use the ‘replace’ checkbox under ‘options’):
- Once restored, make a normal backup of the Sandbox, placing it in to ‘C:\SQLClusterTemp’ directory
- You can now re-enable the sync via the ‘Add Database to Availability Group’ wizard (right click / add under availability groups)
- If all goes well:
Sandbox Refresh EFT Fix
Update AR_ACH_Direct Set Test_Sevice = 'Y';
Update SEFT_Application_Settings Set Automate_Submit_Trans = 0, Automate_Post_Trans = 0, Authorize_Live_Service = 0;
