Good catch. Excellent response. Implementation of custom audit traces may reduce our overall volume of .trc file accumulation....

Shawn Melton (9/21/2010)

---

I currently work as a contractor for the military and if you are following the DoD STIG checklist, C2 Auditing is not required. The checklist has a custom...

I think there are two missing point:

1. I would MOVE the file from source to destination and not COPY to target and then DELETE.

2. I would put a wild card...

ps. (9/21/2010)

---

i would have done...

ps. (9/21/2010)

---

Hey Jeff, the problem will arise when there are multiple files on the folder and he tries to zip them in a loop. there will be seperate wipzip processes...

EdVassie (9/21/2010)

---

Why are you looking at C2 auditing? This is an obsolete standard that does not match current compliance requirements. IMHO you should be looking at Common Criteria,...

Little? LOL

The only way that I can think of to make this synchronus is based on what...

ps. (9/19/2010)

---

let the script zip the files in asynchronous mode, a seperate zip process will be created for each file EXCEPT the current file. just dont touch the current file....

Ananda-292708 (9/20/2010)

---

You can use 7Za a nice standalone tool from 7Zip family.

the synatx is simple

7za.exe a myzip.7 *.bcp >>compress.log

if you find things are asynchronus try calling the batchfile from...

We didn't use PowerShell either until this project for migrating SQL Server 2005 to SQL Server...

Heh... jeez... I guess I've got to do that instead of you looking up how to loop in batch code, huh? 😉 Alright... it's been a thousand years or...

That would be great. 🙂 Please post code for what you have in mind.

I started working on something similar with PowerShell (our preferred scripting language--our DBA team is not skilled in VB script), but, unfortunately, PowerShell calls the zip object asynchronously and the...

In case anyone stumbles across this forum in the future, I thought I would add some information. I don't have a workaround yet, but here is what Microsoft says about...

Actually, this part of the problem. The .trc...