- Remove the sandbox from the availability group:
- Delete the Sandbox from the replicant SQL Server (SQLServer2 in this case)
- Create new backup of Primary Database, checking “Copy-only Backup”
- Doesn’t matter where you place this backup, but ‘C:\SQLClusterTemp’ is as good a place as any:
- Right-click on Databases ->Restore database… Restore the primary data into the Sandbox as normal with a new name (e.g. Companyname_sandbox_20170321) (Don’t forget to use the ‘Overwrite existing with replace’ checkbox under ‘options’):
- Now Expand the Databases>SedonaMaster>Tables>Right-click dbo.company>Edit Top 200 Rows:
- Change the DataSource column for the row with the company name for your sandbox to the new sandbox database name then tab to a new row to commit the changes.
If your databases were synchronizing earlier, you have a few more steps now:
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:
