[dba-SQLServer] SQL Server 2008 compression

jwcolby jwcolby at colbyconsulting.com
Fri Sep 11 12:43:47 CDT 2009


How do you tell once installed, whether you have the X32 or X64 SQL Server installed?  I assume it 
must be X64 because I can give it 12 gigs of ram on my X64 2003 server.

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
> 
> 



More information about the dba-SQLServer mailing list