GilaMonster (10/31/2006)
...Here we zip and archive, so a job goes off once a day, zips all files and copies that zip to the archive server
What do you use as the zip software? Is there a zip tool that gets installed by default by the Windows Server Operating System? (We are using Windows Server 2008.) I'd like to avoid purchasing/installing third party software because it opens Pandora's Box at my site for the security folks.
Also, how do you handle open audittrace*.trc files? When I zip and delete (I am currently testing a convoluted script with PowerShell that I would like to replace), the delete fails when the file is open. Is there a way to force new .trc files without bouncing or failing over SQL Server?