Page History
...
Establishing a migration strategy for the Collection Server allows you to preserve existing audit settings and collected SQL Server events. You can also continue auditing your SQL Server environment to meet your compliance requirements with minimal disruption.
What is the Collection Server?
The Collection Server is the computer that hosts the Collection Service and the Repository databases. For more information, review the product architecture and components.
Migration checklist
Use the following checklist to help you migrate your Collection Server.
| Follow these steps ... |
|---|---|
| Prepare for your migration. |
| Execute your migration by: |
| If you use Microsoft Reporting Services to generate reports about your audit data, configure the Reporting Services data source to use the restored Repository databases. |
| Test your new Collection Server deployment and setup. |
...