--- title: Refresh UAT QA Activate Server from Production slug: refresh-uat-qa-activate-server-from-production createdAt: 2025-06-11T20:26:19.222Z --- This article details the steps to refresh/restore a UAT/QA server from a Production copy of Activate. ## Steps 1. Stop Production server Job Service 2. Backup the Activate Production Database - once backed up restart the Production Job Service 3. Stop the UAT/QA server Job Service, DO NOT restart until specified 4. Backup the existing Activate UAT/QA Database just in case this is needed in the future 5. Restore the Production Database to UAT/QA server SQL Server 6. Run SQL Administrator for UAT/QA Server 7. Run the attached SQL script to set up this database as a QA server.  This script performs the following steps 1. Changes Organisation name to {Current} - TEST 2. Changes the name of the current site to Production 3. Creates a new site named "Restored from Prod" 4. Sets the new SiteID to the current site 5. Updates all non-system parameters to be owned by Production so they don't appear to have been modified locally. 6. Disables and unpublishes all schedulers 7. Disables email approvals 8. Optionally sets the SMTP Server to only save emails to the Activate DB. 9. Cleans up some old parameters no longer in use. 10. Disables all PollWorkflow parameters 11. Clears all emails in a pending state 12. Terminates all active jobs 13. Disables all FileWatcher connectors 14. Removes pending effective groups 15. Removes pending flags from Service Instances 16. Clears expiry dates and ExpiryStarted flags 17. Removes future expiry dates on ADCacheMembers 8. Change Organisation/Name to reflect it’s a UAT/QA server. (\ -UAT for example) 9. Change Roles/System Roles/Users to subset of test users, if required. 10. Configure OverrideUpdatableOU and OverrideEmailAddress, if required 11. Configure Master site, if required 12. Restart the UAT/QA Job Service 13. Recycle the Activate App Pool in IIS 14. Monitor the job log to ensure no Production system jobs have been submitted.