How to move the database to a new SQL server (4243398)

These steps are for version 7.5 or later:

To move the AA database to a new SQL server:

1. Backup the database using SQL Server Management Studio
2. If the database is large and contains old events that are no longer needed, now would be a good time to purge those events:
   - Open the AA console
   - Expand Auditing & Alerting
   - Select Archive & Purging
   - In the top click Purge
   - Select the date that you want to purge events older than and click Purge Now
3. If database maintenance has not been performed regularly, click DB Maintenance and then click Run Now
4. Check to see if the AA_Admin and AA_User groups reside in the Users container in Active Directory or as local groups on the SQL server. If they are in AD proceed to step 7. If they are local groups on the SQL server, proceed to step 5.
5. Create the AA_Admin and AA_User groups as global groups in AD or as local groups on the new SQL server. It is recommended that they be created in AD
6. Add the same accounts from the old groups to the new groups. Members of the AA_Admin groups will have full control over the database, and members of AA_User will be able to run reports against the database. The Active Administrator Agent account, and the account used for the AA service should also be added to the AA_Admin group
7. Open the AA Console
8. Expand Auditing & Alerting
9. Select Agents
10. Select all of the Agents, right click and select Stop
11. Open the AA Server Manager and stop the AFS, ADS and Notification services
12. Using SQL Server Management Studio connected to the old SQL server, detach the AA database and the AA Archive database if it exists
13. Copy the .mdf and .ldf files for the databases to the new SQL server. Alternatively, backup the database and restore to the new SQL server
14. Using SQL Server Management Studio connected to the new SQL sever, attach the database(s)
15. Expand Security | Logins
16. Right click Logins and select New Login
17. Use the Search button and browse for the new AA_Admin group created in step 5
18. Set the Default database to the AA database
19. Select User Mapping
20. Check the AA database and in the bottom select Public and AA_Admin_Role
21. Click OK
22. Right click Logins again and select New Login
23. Use the Search button and browse for the new AA_User group created in step 5
24. Set the Default database to the AA database
25. Check the AA database and in the bottom select Public and AA_User_Role
26. Click OK
27. Open the AA Configuration Wizard
28. Click Next until you get to the Active Administrator Database Configuration page
29. Select Use an existing Active Administrator Database
30. Enter the new SQL sever name and the AA database name and click Next
31. If you moved an existing Archive database to the new server, select Use an existing Active Administrator Archive database or select Create a new Active Administrator Archive database and click Next
32. Click Next through the rest of the Wizard
33. Using the AA Server Manager start the AFS, ADS and Notification services
34. Open the AA Console and select Auditing & Alerting | Agents
35. Uninstall all of the Agents and reinstall them. This step is required as the agents have the database name hardcoded when they are installed