[dba-SQLServer] SQL Server 2008 compression

Arthur Fuller fuller.artful at gmail.com
Fri Sep 11 11:10:24 CDT 2009


I couldn't agree more strongly, Francisco! In fact, I have persuaded several
clients to purchase the Red Gate Toolbelt simply by demo'ing SQL Backup from
my laptop, and illustrating that backups take 1/3 the time and occupy 1/3
the space. And now with the latest version, the space is down to 1/4.
Awesome technology. I especially love the feature that lets you copy the
backup to another machine automatically. That is beautiful!
Arthur

On Fri, Sep 11, 2009 at 11:38 AM, Francisco Tapia <fhtapia at gmail.com> wrote:

> Compression backups?
> one thing to remember is that if you run a backup to a backup device you
> can't have an uncompressed backup with a compressed backup. as far as cost
> it might be cheaper to invest in redgate's backup software wich is fast and
> robust we use it here to backup our 2TB databases. for 295 you really can't
> beat the price on other solutions... its definitely cheaper than going 2008
> enterprise.
>
>
> more info here: http://msdn.microsoft.com/en-us/library/bb964719.aspx
> http://msdn.microsoft.com/en-us/library/ms186865.aspx
>
> alternitavely you may wish to use a free compression product such as:
> http://www.idera.com/Products/Free-Tools/SQL-safe-Freeware-Edition/
>
> -Francisco
> http://sqlthis.blogspot.com | Tsql and More...
>
>
> On Fri, Sep 11, 2009 at 7:05 AM, jwcolby <jwcolby at colbyconsulting.com
> >wrote:
>
> > Does anyone have experience with using compression in 2008?  I understand
> > it is only available in
> > the enterprise edition?
> >
> > --
> > John W. Colby
> > www.ColbyConsulting.com
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>



More information about the dba-SQLServer mailing list