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

Configuring auditing

In this section, we'll discuss the settings that are needed to configure the auditing feature to meet your requirements. There ...
Read More

Auditing user access

Auditing user access If the organization-level auditing is enabled, you can record when a user logs into Microsoft Dynamics CRM ...
Read More

Audit log and database

Managing the audit log Audit operations are stored in an audit log. A separate audit log is created every three ...
Read More

Auditing and what can be audited

Here we start Auditing and what can be audited. What is auditing? In Microsoft Dynamics CRM 2011, the auditing feature ...
Read More

Viewing audit and audit summary and audit history

Here we start  Viewing audit and audit summary and audit history. Viewing the audit data In this section, we'll learn ...
Read More
Loading...

The Practice tests included in this course are:

Exam MB2-700 Microsoft Dynamics CRM 2013 Applications Practice Test 1

Instructions for Exam MB2-700 Microsoft Dynamics CRM 2013 Applications Practice Test 1: Number of Questions: The test has approximately 20-50 ...
Read More

Exam MB2-700 Microsoft Dynamics CRM 2013 Applications Practice Test 2

Instructions for Exam MB2-700 Microsoft Dynamics CRM 2013 Applications Practice Test 2: Number of Questions: The test has approximately 20-50 ...
Read More

Exam MB2-700 Microsoft Dynamics CRM 2013 Applications Practice Test 3

Instructions for Exam MB2-700 Microsoft Dynamics CRM 2013 Applications Practice Test 3: Number of Questions: The test has approximately 20-50 ...
Read More

Exam MB2-700 Microsoft Dynamics CRM 2013 Applications Practice Test 4

Instructions for Exam MB2-700 Microsoft Dynamics CRM 2013 Applications Practice Test 4: Number of Questions: The test has approximately 20-50 ...
Read More

Exam MB2-700 Microsoft Dynamics CRM 2013 Applications Practice Test 5

Instructions for Exam MB2-700 Microsoft Dynamics CRM 2013 Applications Practice Test 5: Number of Questions: The test has approximately 20-50 ...
Read More