question

cstephen avatar image
cstephen asked

How to .zip the sql server user audit files (.sqlaudit) ?

we configured user audit in our Always on availability cluster databases. and .sqlaudit file has the following configurations

USE [master] GO ALTER SERVER AUDIT [UserAudit] TO FILE (MAX_FILES = 0 ) WITH (QUEUE_DELAY = 1003 ) GO

Audit file Maximum limit: Maximum rollover files -->selected unlimited option.

And Maximum File Size: 200 MB

we configured F:/Audit location -->every day we have multiple files like this

example file:

UserAudit_9A092703-DCEC-425A-97C1-4B5D7933B0C3_0_132008916348280000.SQL audit

we need to Zip it when the file size reaches 1 GB to avoid disk space issues. kindly give us any solution or pointers

Regards

stephen

auditmssql2012
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.