Eliminar registros de auditoría del sitio. Tabla dbo.auditdata y stsadm -o trimauditlog

Como administradores de SharePoint nos podemos encontrar ante la circunstancia de tener que eliminar registros de la tabla dbo.auditdata para eliminar registros de la auditoría del sitio.

Hay que tener especial precacución a la hora de habilitar la auditoría de un sitio de SharePoint por el espacio en disco que va a consumir.

Para el caso en que tengamos que eliminar registros de lo auditado, utilizaremos el siguiente comando:

stsadm -o trimauditlog
   -url
   -date
   -databasename
   [-databaseserver] 

Parameter	Value	Required?	Description
url	A valid URL, such as http://server_name	Yes, if databasename parameter is not specified	Specifies the URL name to a site collection. If you use this parameter, it will only delete the audit entries from that site collection. If this parameter is used, the databaseserver and databasename parameters are ignored.
date	A valid date in the form "YYYYMMDD"	Yes	Represents the earliest date and time for which the user wants to preserve audit data.
databasename (dn)	A valid database name, such as "DB1"	Yes, if url parameter is not specifed	Specifies the name of a content database where the audit log should be trimmed.
databaseserver (ds)	A valid database server, such as "DS1"	No	Name of the database server where the content database is stored. Note: If your database server and SharePoint Products and Technologies are hosted on separate servers, you need to use the databaseserver parameter to specify the database server name.

Extraido de:

http://technet.microsoft.com/en-us/library/cc706879%28office.12%29.aspx