none
sql server compressed backup with t-sql in sql server web edition

    Question

  • Hi ALL,

    Please let me know if I can do the compressed backup with t-sql code in sql server web edition .

    Thanks,

    C.


    • Edited by chinna738 Friday, September 20, 2013 2:14 PM
    Friday, September 20, 2013 2:13 PM

Answers

  • Hi, backup compression is not supported in Web Edition.  In SQL Server 2008 backup compression was only supported in Enterprise edition.  In 2008 R2, it is supported in Datacenter, Enterprise, and Standard.  In 2012, it is supported by Enterprise, BI, and Standard.

    Here is the complete feature by edition list:

    http://msdn.microsoft.com/en-us/library/cc645993(v=sql.100).aspx

    Thanks,
    Sam Lester (MSFT)


    http://blogs.msdn.com/b/samlester

    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.


    Friday, September 20, 2013 2:24 PM