Error delete old audit File

• abdalah.mehdoini

  Ten Centuries

  Points: 1012

  More actions

  January 22, 2024 at 8:49 pm

  #4366014

  Hello ,

  I recently set up a SQL database audit to record a few sessions.

  The audit configuration is well done with retention of 2 files

  Everything works correctly except that in the error log I have this message which indicates that SQL server can no longer delete the old audit file because it seems to me that it is still running

  Do you have any idea how I can fix it?

  Tthanks

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  January 23, 2024 at 7:38 am

  #4366202

  Set the nessesary exclusion on any scanning software, use handle/procmon to see if anyone / anything is using the file when SQL tries the delete.

   

  Error 32 is “ERROR_SHARING_VIOLATION” something else is holding a file lock so SQL cannot delete it.