jeff.mason (3/14/2011)
...I can get between 30 to 90 percent compression on databases, depending upon the contents and datatypes (straight text and numbers compress VERY well)...
Thanks! That will save me some research time.
I'll keep the job around for older systems.
Never had a problem with 7zip hanging. Although it's not directly called from the agent. I'm using the agent to call a VBScript that handles business rules for archiving the zip files and deleting the older ones per the specified requirements. The script calls 7zip and also does more logging than the job. Haven't had any issues with this method yet... 🙂