Answered by:
SQL 2008 Backup Compression vs SQL 2012 Backup Compression

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 -