locked
SQL 2008 Backup Compression vs SQL 2012 Backup Compression RRS feed

  • Question

  • Hello,

    I would like to know if there is any difference between the backup compression in SQL Server 2008, and the backup compression in SQL Server 2012. Does 2012 use a different algorithm? Is it more efficient in any way?

    Thanks in advance

    Monday, November 4, 2013 3:44 PM

Answers

All replies

  • One I just got to know was backup compression was not supported in SQL serer 2008 standard while in SQL server 2012 Standard Backup compression is supported.I would suggest you to read below artilce

    http://technet.microsoft.com/en-us/library/bb964719(v=sql.105).aspx

    In above link Click other versions to read this feature in 2012.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Monday, November 4, 2013 3:48 PM
  • Thank you for the link Shanky.

    I knew what versions had backup compression, but I just want to know if the backup compression in 2012 is in any way more efficient than backup compression in 2008.

    Thanks

    Monday, November 4, 2013 4:01 PM
  • One I just got to know was backup compression was not supported in SQL serer 2008 standard while in SQL server 2012 Standard Backup compression is supported.I would suggest you to read below artilce

    http://technet.microsoft.com/en-us/library/bb964719(v=sql.105).aspx

    In above link Click other versions to read this feature in 2012.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Actually Shanky_621 this was changed in SQL server 2008 R2.    SQL  2008 standard did not support backup compression.   SQL Server 2008 R2 Standard does support backup compression.

    Monday, November 4, 2013 4:23 PM
  • One I just got to know was backup compression was not supported in SQL serer 2008 standard while in SQL server 2012 Standard Backup compression is supported.I would suggest you to read below artilce

    http://technet.microsoft.com/en-us/library/bb964719(v=sql.105).aspx

    In above link Click other versions to read this feature in 2012.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Actually Shanky_621 this was changed in SQL server 2008 R2.    SQL  2008 standard did not support backup compression.   SQL Server 2008 R2 Standard does support backup compression.

    Geremy,

    I am aware about this :)  .I only mentioned 2012 as R2 was not in picture


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Monday, November 4, 2013 4:27 PM
  • Hi BFDEV91,

    I have performed some tests on these using a 1.7GB database, both versions of SQL compressed it to 174MB.   It looks like they use the same compression methods.   This is not an article on compression ratio, your mileage may vary.

    Thanks,

    _______________________________________________________________________________________

    Please click the Mark as answer button if I answered your question, and vote as helpful if this reply helps you. Thank you!

    Monday, November 4, 2013 4:33 PM
  • No,  there is no difference.

    Please see:

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

    • Marked as answer by BFDEV91 Monday, November 4, 2013 6:01 PM
    Monday, November 4, 2013 4:50 PM