none
Compress backup sql server 2008 standard edition 64 bits

    Question

  • Actually I have sql server 2008 standard edition 64 bits.

    My problem is that when I create maintenance plan for compress backup its is giving error that it not supported in 64 bit.

    Actually database size is too large so compress backup is only solution.

    Thanks.

    Wednesday, February 22, 2012 11:43 AM

Answers

All replies

  • Backup compression isn't supported by SQL Server 2008 Standard Edition.

    Backup compression for Standard edition of SQL Server is supported only in SQL Server 2008 R2 or higher versions.


    Ana Mihalj

    Wednesday, February 22, 2012 12:23 PM
  • The only  SQL Server 2008 edition that support backup compression is the enterprise endition. Although you can't backup with compression on std versions, you can RESTORE from compressed backups.

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

    VT


    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    Wednesday, February 22, 2012 12:30 PM