SQL Server 2008 R2 Features

  • Abi Chapagai

    SSCrazy

    Points: 2666

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

  • UMG Developer

    SSChampion

    Points: 13482

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

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 716619

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

  • M&M

    SSC-Insane

    Points: 21679

    I found the answer in below link.

    http://www.sqlmag.com/article/sql-server-2008-r2/SQL-Server-2008-R2-New-Features.aspx

    M&M

  • Koen Verbeeck

    SSC Guru

    Points: 258955

    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

  • Abi Chapagai

    SSCrazy

    Points: 2666

    Koen Verbeeck (3/13/2011)


    Very nice question, thanks.

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

  • tejaswini.patil

    SSCommitted

    Points: 1782

    Thanks for a good question.

    I found my answer in following url;

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

  • Duncan Pryde

    SSCertifiable

    Points: 7956

    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

  • Duncan Pryde

    SSCertifiable

    Points: 7956

    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

  • Chris Houghton

    SSCrazy

    Points: 2497

    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.

  • Abi Chapagai

    SSCrazy

    Points: 2666

    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.

  • Surii

    Default port

    Points: 1477

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

    Nice question. Thanks

  • Dave62

    SSCertifiable

    Points: 6465

    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.

  • jeff.mason

    SSCrazy Eights

    Points: 9555

    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.

  • Dave62

    SSCertifiable

    Points: 6465

    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 19 total)

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