Automatic Deletion of Trace files from MSSQL server
Originally Published: 2014-11-19
Article Number
Applies To
Issue
The files can be deleted automatically but it will be very un-productive to do so on a daily basis.
Resolution
Where "xxxx" which is encapsulated in the angular brackets represent the version of the MSSQL Server like 2005, 2008 etc
In the file sqlServerAudit<xxxx>.sql
Replace:
exec @rc = sp_trace_create @traceid output, 2, @filename, @maxfilesize, @endtime
With
exec @rc = sp_trace_create @traceid output, 0, @filename, @maxfilesize, @endtime
Related Articles
RSA Community Quickstart Guide Number of Views SilverFort - RSA MFA API (REST) Configuration - RSA Ready Implementation Guide Number of Views CrowdStrike Falcon Identity Protection - Authentication Manager - RSA MFA API (REST) Configuration - RSA Ready Implementat… Number of Views RSA enVision Security Hot Fix for - 109122-105523 Number of Views How do I subscribe to product advisories on the RSA Community? Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.9 Release Notes (January 2026) An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
