Before the archive process can be run, you must add the connection string for the database on which the Audit_Log_Transfer Database Table was created to the ControlPoint Configuration Setting Archive Audit Log Table Connection String.
TIP: You can copy and paste the Value from the ControlPoint Configuration Setting SQL Server Connection String for XcAdmin Database, and update the following values:
·For Data Source=, the name of the server on which the Audit_Log_Transfer Database Table resides.
·For Initial Catalog=, the name of the database in which the Audit_Log_Transfer Database Table was created.
You can run the archive audit log process using any of the following methods:
·For the entire farm or for individual Web applications, from the ControlPoint application interface
·On the server where ControlPoint xcUtilities resides:
§From the xcUtilities interface
§From a command line
§On a one-time or recurring basis, through Windows Task Scheduler
Log in Account Requirement:
On the server that hosts the content databases containing the audit log data you want to archive, you must be logged in with an account that has administrative privileges for every Web application that you intend to include in the archive process.
You can archive audit log data for the entire farm or for individual Web applications from the ControlPoint application interface. This is especially useful before moving a site collection, because once a site collection has been deleted from the source location its audit log data remains in the content database and becomes "orphaned."
1From the Manage ControlPint tree, choose ControlPoint Management > Audit Log Archive.
2In the Available items section, select either the farm node or the individual Web applications whose audit log data you want to archive.
3Select the Parameters tab then enter the Number of Days to Keep in Audit Logs (that is, any audit log data that has been captured before this time period will be archived). If you want to archive all audit log data before deleting or moving a site collection, enter 0.
Now you can:
·run the operation immediately (by clicking the [Run Now] button)
To run the archive process from the ControlPoint xcUtilities interface:
1On the Web front-end server where the archive was set up, open xcUtilities.exe, located in C:\Program Files\Metalogix\ ControlPoint\ControlPointFeatures.
2Under Archive Audit Log, enter the # Of Days to Keep in SharePoint.
Any audit log data that has been captured before this time period will be archived.
3To initiate the archive process, click [Archive Audit Log].
NOTE: If you click [Cancel Archive] after the process has been initiated, the utility will finish archiving data for the current process interval before ending.