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.
12,852 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,818 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.
496 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,248 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vahid Ghafarpour 18,450 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