Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Posts
    1,245

    Unanswered: 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 Scott

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    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.
    Last edited by Paul Young; 01-10-03 at 11:24.
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •