SQL Server 2008 R2 Features

  • Comments posted to this topic are about the item SQL Server 2008 R2 Features

  • Thanks for the question. And I am glad that MS finally added backup compression to the standard edition.

  • Me too, now if they'd move a few more features, I'd be thrilled.

  • Very nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck (3/13/2011)


    Very nice question, thanks.

    Thank you all for the comments. This is my first question.

  • Thanks for a good question.

    I found my answer in following url;

    http://www.microsoft.com/sqlserver/2008/en/us/R2-editions.aspx

  • Really good question. And useful too - I'd written off backup compression as an Enterprise-only feature, and since our clients only use Standard I'd not investigated it properly. I will now though.

    Thanks

    Duncan

  • Abi Chapagai (3/13/2011)


    Koen Verbeeck (3/13/2011)


    Very nice question, thanks.

    Thank you all for the comments. This is my first question.

    I look forward to your second one!

    Duncan

  • Definitely a question with practical value. It's just a shame that Microsoft hiked the price up so much for R2, I can't persuade the decision makers to go for it.

  • Duncan Pryde (3/14/2011)


    Abi Chapagai (3/13/2011)


    Koen Verbeeck (3/13/2011)


    Very nice question, thanks.

    Thank you all for the comments. This is my first question.

    I look forward to your second one!

    Duncan

    Thanks Duncan, I will try to post another question.

  • I was reading through all this features yesterday. It was an easy one for me.

    Nice question. Thanks

  • A while ago I implemented an SQL Server job that uses 7zip to compress backups after they run. I've been getting between 80 and 85 % compression.

    When we upgrade I'll have to test out the built-in compression to see if the percentage is comparable. Either way the job may still come in handy in places that are slow to upgrade.

  • Dave62 (3/14/2011)


    A while ago I implemented an SQL Server job that uses 7zip to compress backups after they run. I've been getting between 80 and 85 % compression.

    When we upgrade I'll have to test out the built-in compression to see if the percentage is comparable. Either way the job may still come in handy in places that are slow to upgrade.

    I can get between 30 to 90 percent compression on databases, depending upon the contents and datatypes (straight text and numbers compress VERY well). And the beauty is twofold -- one, it's only one step instead of two, and the one step is not much longer if at all longer than the original first step of making the backup in the first place, so you might cut your time in half in theory. Second, it doesn't require the Agent to run a command line utility. We did that in 2000 with WinRar and I found that upon occasion WinRar would hang, and so the job would hang and never complete or error out. Not an issue here. We have moved to compressing ALL 2008 backups as a matter of course; even if it is not much space savings, it is some and minimal overhead. A truly great feature to have.

  • jeff.mason (3/14/2011)


    ...I can get between 30 to 90 percent compression on databases, depending upon the contents and datatypes (straight text and numbers compress VERY well)...

    Thanks! That will save me some research time.

    I'll keep the job around for older systems.

    Never had a problem with 7zip hanging. Although it's not directly called from the agent. I'm using the agent to call a VBScript that handles business rules for archiving the zip files and deleting the older ones per the specified requirements. The script calls 7zip and also does more logging than the job. Haven't had any issues with this method yet... 🙂

Viewing 15 posts - 1 through 15 (of 18 total)

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