Page History

...

Use the following checklist to help you migrate your Collection Server.

Image Modified	Follow these steps ...
Image Modified	Prepare for your migration.
Image Modified	Execute your migration by: Restoring the Repository databases Deploying the new Collection Server Configuring the SQLcompliance Agent connection
Image Modified	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.
Image Modified	Test your new Collection Server deployment and setup.

...

• To minimize audit data loss, plan to backup the Repository databases on the temporary Collection Server immediately before reinstating the original Collection Server
• Use these migration procedures to reinstate the Collection Server on the original computer, configure the SQLcompliance agents, and configure Reporting Services
• To verify all components were reinstated correctly, test your implementation
• Uninstall the Collection Server you previously implemented on the temporary computer

SQL SQL Compliance Manager audits audits all activity on your server.  Learn more > Learn more > >

...