Sharepoint 2010 and Backup Compression

• jspatz

  Ten Centuries

  Points: 1314

  More actions

  July 21, 2011 at 2:01 pm

  #244695

  Should we be doing it??

  This article highly recommends using it

  http://technet.microsoft.com/en-us/library/cc261687.aspx

  This article states it is not supported for Sharepoint 2010 Products, except for the Search service application databases

  http://technet.microsoft.com/en-us/library/cc298801.aspx

  Hence .. my confusion 🙂

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  July 22, 2011 at 3:02 am

  #1356894

  I think you're confusing data compression within the database and compressed backups.

  Compressed backups are fine, but if you want to use page or row compression ( depending on your sql version ) this isn't supported in sharepoint ( except for the search database )

  I use litespeed with sharepoint with no problems.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/