Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
SQL Server ERRORLOG is growing and information events are added often
Description
When working with Change Auditor and enabling SQL Server Data Level Auditing (DLA) you may notice that the SQL Server ERRORLOG file is growing. After reviewing the ERRORLOG file you find that there are a lot of DBCC TRACEON\OFF messages.
Cause
We have created the following enhancement request:
VSTS#20603 - As a CA Administrator, I would like the CA agent to not record DBCC TRACEON messages in SQL ErrorLog when DLA auditing is enabled
Resolution
We did find reference to trace flag -T2505 which can be added to the start-up parameters of the SQL Server service. This flag would disable the DBCC TRACEON\OFF log entries. The flag is undocumented so you should be cautious if you decide to go that route.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Recommended Content
Product(s):
Change Auditor
Topic(s):
Configuration
Article History:
Created on: 2/28/2018 Last Update on: 5/7/2023
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
Search All Articles
IE 8, 9, & 10 No longer supported
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.
