SQL Server 2008 R2 Features

Question

Post reply

SQL Server 2008 R2 Features

Abi Chapagai

SSCrazy

Points: 2666
More actions
March 12, 2011 at 1:15 pm

#233834

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

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

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

UMG Developer SSChampion Points: 13482 More actions · Answer 1

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: 736172 More actions · Answer 2

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

M&M SSC-Insane Points: 21700 More actions · Answer 3

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: 259105 More actions · Answer 4

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 More actions · Answer 5

Koen Verbeeck (3/13/2011)
Very nice question, thanks.

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

tejaswini.patil SSCommitted Points: 1812 More actions · Answer 6

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 More actions · Answer 7

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 More actions · Answer 8

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: 2557 More actions · Answer 9

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 More actions · Answer 10

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: 1497 More actions · Answer 11

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

Nice question. Thanks

Dave62 SSCertifiable Points: 7459 More actions · Answer 12

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: 9585 More actions · Answer 13

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: 7459 More actions · Answer 14

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... 🙂