A migration strategy moves the Collection Server components to another SQL Server instance, thereby replacing the original Collection Server. You can use a migration strategy to respond to an immediate maintenance need. Use the following procedures and guidelines to implement a new migration strategy or modify an existing migration strategy.

Verify the configuration of the target SQL Server

When identifying the new SQL Server instance that will host the Collection Server, ensure this instance meets or exceeds the product hardware, software, and permissions, as well as these specific requirements:

Back up the Repository databases

Use a tool such as IDERA  to perform a full backup of the Repository databases, including transaction logs. You can back up event and archive databases separately from the SQLcompliance databases. However, for best results during a disaster recovery, fully restore all Repository databases at the same time.

 |   |  |  |  |