Post reply

SQL Server 2008 R2 backups with data compression

  • June 13, 2011 at 8:13 am

    #242056

    We are currently only doing non compressed backups. I tried the SQL Server 2008 R2 Backup with compression and it was faster on Backups and Restores. It also only used a fraction of the disk space for the backup file. Has anyone had any negative issues using the compression option with SQL Server 2008 R2?

    Thank you in advance,

    Charlie

  • June 13, 2011 at 8:22 am

    #1337776

    We use it for full, differential, and transaction log backups, and have never had a problem with it.

  • June 13, 2011 at 8:24 am

    #1337777

    been using it for about 6 months with no issues.

    ---------------------------------------------------------------------

  • June 13, 2011 at 8:31 am

    #1337786

    Thank you for the information Michael. I have discussed Differential backups with my manager in the past and I think I need to push for it again. Thanks again!

    Charlie

  • June 13, 2011 at 8:32 am

    #1337787

    Thanks for the information George. This sounds very encouraging.

    Charlie

  • June 13, 2011 at 8:57 am

    #1337808

    I have not heard about any issues with it. It's a fairly simple process and works well.

    The third party tools do a better job of compression, but at the expense of CPU and also the cost of the tools.

  • June 13, 2011 at 9:30 am

    #1337840

    It was running for years with no issues at my previous employer.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • June 15, 2011 at 1:27 am

    #1338790

    Hi,

    The backup compression is a great feature in SQL Server 2008.But since the backup of the database is in compressed state,it takes a longer time for the database to come online.One more thing is the compressed backups are not compatible with the previous versions of sql server.

    Regards,

    S.Srivathsani

  • June 15, 2011 at 1:36 am

    #1338791

    I am curious, what sort of compression rates do you get? i use 3rd party tools and get 70-80% compression.

  • June 15, 2011 at 2:47 am

    #1338814

    srivathsani-296624 (6/15/2011)

    Hi,

    The backup compression is a great feature in SQL Server 2008.But since the backup of the database is in compressed state,it takes a longer time for the database to come online.One more thing is the compressed backups are not compatible with the previous versions of sql server.

    Regards,

    S.Srivathsani

    There are NEVER backward compatible.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply