script to compress files one by one

[Tiago_Aurelio]

Hello people



We have SQL Server 2016 with audit trails enabled, generating files like this:


Audit_Siplan_CA719560-60F6-4F43-9CB6-3B6EF6CAD9D0_0_132053405773920000.sqlaudit


Audit_Siplan_CA719560-60F6-4F43-9CB6-3B6EF6CAD9D0_0_132053433183930000.sqlaudit



Each one with 1 GB, being that at the end of the day I have around 20 files of these of 1 Gb each.



I need a routine to compress these files, so I can send them to the cloud, already tried with 7-zip, and winrar but it did not work.



I need compression to keep the files name and not everything in a single file



Can anyone help me with this?

Continue reading...