Share via

SQL audit file Rollover is not working

Uddandam Prasanth (QUANTUM LEAP CONSULTING PRIVAT) 0 Reputation points Microsoft Vendor
2023-10-17T04:53:52.17+00:00

HI all.

SQL audit file Rollover is not working

I try. The SQL Service account has full permissions to the folder, and I Try disable/enable the audit session to see if it removes the file. and it works for some days.

Please give me some advice.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,746 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,918 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
530 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,282 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vahid Ghafarpour 21,235 Reputation points
    2023-10-30T02:44:42.73+00:00

    When you set MAX_Files, SQL does not roll over to the first file when the limit is reached, nor does it remove files.

    https://learn.microsoft.com/en-us/sql/t-sql/statements/create-server-audit-transact-sql?view=sql-server-ver16&redirectedfrom=MSDN

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.