Microsoft has released documentation describing how to integrate MOSS 2007 with SQL 2008 to enable the usage of SQL 2008 features like

  • Database backup compression
  • Log stream compression 
  • TDE (transparent data encryption)

Integration of SQL Server 2008 and Office SharePoint Server 2007