[AccessD] OT RE: Rar vs winzip

About 8:1.   These were SQL Server database files and they do compress
pretty well.  Not particularly fast however.

I have a bunch of SQL Server database files that I will likely never need
again.  Some big ones were the SOURCE databases that I further refined and
now just sit there.  I don't want to just delete them, but I also don't want
to take up a hundred gigs of any kind of storage holding them.  I want them
OFF of my main system in case anything goes wrong.  To turn the 100 gig file
into a 12 gig file suddenly makes it easily archivable.  Not easy to get
back but that is the point exactly, I don't really expect to ever need to.

OTOH I have a bunch of little database files that I store the orders in.
These files average a few megs up to a couple of hundred megs.  These I can
zip using WinZip but still get a useful shrink, and they don't take THAT
long to zip / unzip.  I can then store them NearLine, on a different system
but easily available if the client ever asks a question about them.  I have
my active HUGE databases which I need to store NearLine without zipping at
all.  If I ever need them back I will want them ASAP.  Even doing a straight
copy from disk to disk within the same system takes hours when it is a 100
gig file.

As you can see I need to use a variety of tools to handle all of this.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Monday, February 11, 2008 1:08 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] OT RE: Rar vs winzip

JC:

Curious, what was the compression ratio with RAR on the 100 gig file?  

Rocky