Maintenance
Refresh UAT QA Activate Server from Production
2 min
this article details the steps to refresh/restore a uat/qa server from a production copy of activate steps stop production server job service backup the activate production database once backed up restart the production job service stop the uat/qa server job service, do not restart until specified backup the existing activate uat/qa database just in case this is needed in the future restore the production database to uat/qa server sql server run sql administrator for uat/qa server run the attached sql script to set up this database as a qa server this script performs the following steps changes organisation name to {current} test changes the name of the current site to production creates a new site named "restored from prod" sets the new siteid to the current site updates all non system parameters to be owned by production so they don't appear to have been modified locally disables and unpublishes all schedulers disables email approvals optionally sets the smtp server to only save emails to the activate db cleans up some old parameters no longer in use disables all pollworkflow parameters clears all emails in a pending state terminates all active jobs disables all filewatcher connectors removes pending effective groups removes pending flags from service instances clears expiry dates and expirystarted flags removes future expiry dates on adcachemembers change organisation/name to reflect it’s a uat/qa server (\<company name> uat for example) change roles/system roles/users to subset of test users, if required configure overrideupdatableou and overrideemailaddress, if required configure master site, if required restart the uat/qa job service recycle the activate app pool in iis monitor the job log to ensure no production system jobs have been submitted