Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Send To Compressed (zipped)... in Windows 2003

Author  Topic 

CanadaDBA

583 Posts

Posted - 2006-03-09 : 11:24:48
I want to zip my backups and FTP to another machine. The problem is that ZIP.EXE has a limitation of 4GB. Is there any command line for the "send to Compress..." in Windows 2003?

Thanks,

Canada DBA

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-03-09 : 11:30:08
split the files into smaller chunks...

Go with the flow & have fun! Else fight the flow
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2006-03-09 : 11:39:49
Or use pkzip or similar tools..
Go to Top of Page

CanadaDBA

583 Posts

Posted - 2006-03-09 : 11:47:03
Thanks folks for the comments but I want to find out the command line for file compression in Windows 2003, if there is any.

Canada DBA
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-03-09 : 12:09:07
You can compress files larger than 2GB with PKZIP Version 5.00 or later, and it has a command line option.

The cost is fairly nominal even for a site license.




CODO ERGO SUM
Go to Top of Page

Tahsin
Starting Member

34 Posts

Posted - 2006-03-09 : 12:13:04
Try "compact" in command line
"compact/?" to get a list of parameters
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-03-09 : 13:05:18
"I want to find out the command line for file compression in Windows 2003"

The PKZIP boys have a command line version (which I have used for this purpose), as do the WinZip boys I believe.

You may want to also PGP the files if you are going to FTP them! (Do the PGP after the ZIP otherwise they won't compress much)

Kristen
Go to Top of Page

CanadaDBA

583 Posts

Posted - 2006-03-09 : 13:34:31
This command is not for the reason I am looking. I am looking for somthing in Windows like pkzip. We can buy the pkzip or Winzip but I want to find out what program in Windows does the compression.

quote:
Originally posted by Tahsin

Try "compact" in command line "compact/?" to get a list of parameters



Canada DBA
Go to Top of Page

CanadaDBA

583 Posts

Posted - 2006-03-10 : 10:15:32
Does anyone know what is the compression command in Windows 2003?

Canada DBA
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-03-11 : 11:37:43
I didn't know there was one - other than setting the File Property to "compressed"

Kristen
Go to Top of Page
   

- Advertisement -