Automating File Compression in as a scheduled task - (command line script) --- Windows 2000
Posted on 2004-09-28
I have a customized SQL database that does a nightly backup to a backup folder.
The file naming structure embeds the date and time into the file name. Example: oasis_db_200409282000.bak
My backup database file size exceeds 4GB.
I am needing to compress this file so that I can manange it with my tape backup.
I have tried using gzip to compress the file. This works great and reduces the file to 750MB.....perfect size.
My problem is I don't know how I can accomodate the changing file name. gzip doesn't allow wildcards.
I am running Windows 2000 Server where my database is located.
Is there another way/method to accomodate this task?