Purging the SQL Server Log

I am required by my customer to audit all logins to the SQL Server database. I have the Audit Level set to 'All'. What I have noticed is that SQL Agent is constantly logging in which is rapidly bloating the size of the ERRORLOG. It's now at 90MB, but once it gets beyond 12 MB it becomes pretty much unusable as a tool.

Is there some way to eliminate SQL Agent from the Audit process?

Alternatively, is there some way to "roll" the log (much like SQL Server does at start-up) while SQL Server is still running?

Any input is welcome.

Regards,

Hugh Scottwhat version of SQL Server are you running? If 2k then try sp_cycle_errorlog.

I am not aware of a way to exclude a user's activity from the audit process.|||Thank you sir!!

Hugh Scott

Originally posted by Paul Young
what version of SQL Server are you running? If 2k then try sp_cycle_errorlog.

I am not aware of a way to exclude a user's activity from the audit process.