locked
BOL InCorrect? Backup Compression in SQL 2012 Standard Edition RRS feed

  • Question

  • SQL 2008 r2 standard edition comes with Backup Compression however

    Does backup compression is availbale in SQL 2012 standard edition? I do not have SQL 2012 media yet just confirming as MSDN Books Online incorrectly states that it is not available in standard edition

    Creating compressed backups is supported only in SQL Server 2008 Enterprise and later, but every edition of SQL Server 2008 and later can restore a compressed backup.

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


    • Edited by Chirag Shah Wednesday, April 4, 2012 7:53 PM
    Wednesday, April 4, 2012 7:33 PM

Answers

  • Hi Chirag, you are correct that this is a documentation bug.  It is supported in Standard and BI edition in SQL Server 2012 as well and is listed here in the "features supported by edition" document:

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

    Thanks,
    Sam Lester (MSFT)


    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.


    Wednesday, April 4, 2012 10:27 PM

All replies

  • Hi Chirag, you are correct that this is a documentation bug.  It is supported in Standard and BI edition in SQL Server 2012 as well and is listed here in the "features supported by edition" document:

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

    Thanks,
    Sam Lester (MSFT)


    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.


    Wednesday, April 4, 2012 10:27 PM
  • Sam,

    Do you know if Backup Compression in 2012 is in anyway more efficient than backup compression in the 2008 editions? Does it use a different algorithm or anything like that?

    Thanks

    Bryan

    Monday, November 4, 2013 4:18 PM