jwcolby
jwcolby at colbyconsulting.com
Fri Sep 11 12:31:15 CDT 2009
Francisco, From what I am reading, the compression works at all times, but ALSO during the backup. I am sure there is a "cost" in application / database speed. In the end, AFAICT it is only available in the enterprise edition which is way out of my budget range. I was really just wondering if anyone had ever used it. Thanks for the links though. I will go take a look at their free stuff. I paid about $700 for another company's product but I was going to have to pay to move to SQL Server 2005 (and now 2008) so I didn't. I NEED backups! Again, thanks for the links. John W. Colby www.ColbyConsulting.com Francisco Tapia 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 > >