<div>
Hi,<br />
<br />
You can set up compression on the folder where the .bak file is placed, to do so, right click on the designated folder, then on the general tab, choose Advanced. On the advanced tab, check the &nbsp;&quot;Compress data to free up space&quot;.. Don't really know how much it will safe ya..
</div>


Hi,

You can set up compression on the folder where the .bak file is placed, to do so, right click on the designated folder, then on the general tab, choose Advanced. On the advanced tab, check the  "Compress data to free up space".. Don't really know how much it will safe ya..

<div>
I will give this a try in the next day or two. &nbsp;My actual data path is in d:\sql_backups. &nbsp;The gzip command line goes like this;<br />
<br />
gzip -c filename.bak &gt;&nbsp;filename.gz<br />
<br />
Thanks a million.
</div>


I will give this a try in the next day or two.  My actual data path is in d:\sql_backups.  The gzip command line goes like this;

gzip -c filename.bak > filename.gz

Thanks a million.

<div>
<div class="content wysiwyg-content">
I have a customized SQL database that does a nightly backup to a backup folder.<br />
<br />
The file naming structure embeds the date and time into the file name. &nbsp;Example: oasis_db_200409282000.bak<br />
<br />
My backup database file size exceeds 4GB.<br />
<br />
I am needing to compress this file so that I can manange it with my tape backup.<br />
<br />
I have tried using gzip to compress the file. &nbsp;This works great and reduces the file to 750MB.....perfect size.<br />
<br />
My problem is I don't know how I can accomodate the changing file name. &nbsp;gzip doesn't allow wildcards.<br />
<br />
I am running Windows 2000 Server where my database is located.<br />
<br />
Is there another way/method to accomodate this task?<br />
<br />
Thanks.
</div>
</div>


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?

Thanks.

Automating File Compression in as a scheduled task - (command line script)  --- Windows 2000

Windows 2000 is an operating system for use on both client and server computers. It is the successor to Windows NT 4.0, and is the last version of Microsoft Windows to display the "Windows NT" designation. Four editions of Windows 2000 were released (Professional, Server, Advanced Server, and Datacenter Server) that shared a core set of features, including many system utilities such as the Microsoft Management Console. All versions of the operating system support NTFS 3.0, Encrypting File System, as well as basic and dynamic disk storage. The Windows 2000 Server family includes support for Active Directory services, Distributed File System and fault-redundant storage volumes.