Managing the audit log
Audit operations are stored in an audit log. A separate audit log is created every three months. Over time, these audit logs can consume a significant amount of storage on your database server (for the CRM on-premise deployments) or your allocated storage space (for the CRM Online deployments). If database storage is a concern, you can delete the audit logs when it is no longer necessary to store them according to your organization’s record retention policy.
Note: Deleting multiple audit logs
You can only delete the oldest audit log. Repeat the following procedure, if you wish to delete more than one audit log.
To delete an audit log, follow these steps:
1. In the navigation pane, click on Settings.
2. Then in the System group, click on Auditing.
3. Click on Audit Log Management.
4. Select the oldest audit log and click on the Delete Logs button.
5. In the confirmation message, click on OK.
Audit logs in the database
Audit operations are stored in the non-customizable audit system entity.An audit log in Microsoft Dynamics CRM represents a logical collection of audit operations. How audit logs are managed depends on which version of Microsoft SQL Server is deployed.
Microsoft Dynamics CRM 2011 uses Microsoft SQL Server as its database management system. Three editions of Microsoft SQL Server 2008 are supported—Standard,Enterprise, and Datacenter.
For on-premise deployments that use Microsoft SQL Server 2008 Enterprise or Datacenter editions, and for Microsoft Dynamics CRM Online, audit operations re stored in physical database partitions. A new physical partition is created every three months. Each partition acts like a separate table which ensures that the performance of the auditing feature isn’t affected too much as the database grows. Each partition represents an audit log in Microsoft Dynamics CRM 2011 and is measured in kilobytes.
Microsoft SQL Server 2008 Standard Edition does not support database partitions so for on-premise deployments that use Microsoft SQL Server 2008 Standard edition audit operations are stored in the CRM organization database. An audit log in Microsoft Dynamics CRM 2011 represents a collection of audit operations
grouped by calendar quarter and is measured in rows.
Microsoft SQL Server 2012
Support for Microsoft SQL Server 2012 Standard, Business Intelligence and Edition editions was introduced with Update Rollup 6 for Microsoft Dynamics CRM 2011 in January 2012.
The MB2-866 exam was published before Microsoft SQL Server 2012 or Update Rollup 6 for Microsoft Dynamics CRM 2011 were released, so questions about audit partitions related to Microsoft SQL Server 2012 are unlikely.
Questions about audit partitions related Microsoft SQL Server 2008 are still possible.
This is a part of Auditing in CRM 2011 chapter from MB2-866 Microsoft Dynamics CRM 2011 Customization and Configuration Prep course. More lessons in this chapter are
The Practice tests included in this course are: