You can execute a migration strategy that addresses one of the following situations:
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.
The Collection Server is the computer that hosts the Collection Service and the Repository databases. For more information, review the Product components and architecture.
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 , change the Reporting Services data source to use the restored Repository databases.
Test your new Collection Server deployment and setup.
Before you execute your migration strategy, decide whether you will want to permanently move the Collection Server to another computer.
If you expect to replace the Collection Server , ensure you have an available SQL Server that can be a dedicated host for the Collection Server. This computer should meet or exceed the product requirements.
If you expect to repair the original Collection Server computer , ensure your strategy includes plans to reinstate the original computer once it is repaired. Consider the following guidelines: