Backup Compression

Question

Post reply

Backup Compression

lbrigham

SSCommitted

Points: 1567
More actions
July 30, 2012 at 8:43 pm

#259937

Comments posted to this topic are about the item Backup Compression
July 31, 2012 at 7:04 am

This was removed by the editor as SPAM

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

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Nice easy question to start the week ...

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 2

Very nice question. The 2012-version of BOL isn't really clear:

In SQL Server 2008 Enterprise and later versions only

http://msdn.microsoft.com/en-us/library/ms186865.aspx

but the 2008R2 documentation is pretty specific:

Backup compression was introduced in SQL Server 2008 Enterprise. Beginning in SQL Server 2008 R2, backup compression is supported by SQL Server 2008 R2 Standard and all higher editions.

http://msdn.microsoft.com/en-us/library/ms186865(v=sql.105).aspx

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

Sreepathi1987 Default port Points: 1425 More actions · Answer 3

Sreepathi1987

Default port

Points: 1425

July 31, 2012 at 1:11 am

#1519544

Good Question.......

Divine Flame SSCoach Points: 15943 More actions · Answer 4

Nice, easy one 🙂 With total 6 options available as answer choosing 5 was easy by leaving the SQL Server 2008 Standard Edition.

Sujeet Singh

D.Oc SSCrazy Points: 2875 More actions · Answer 5

Nice one,

why not put all related links

Features Supported by the Editions of SQL Server 2008

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

Features Supported by the Editions of SQL Server 2008 R2

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

Features Supported by the Editions of SQL Server 2012

http://technet.microsoft.com/en-us/library/cc645993.aspx

-------------------------------------------------------------
"It takes 15 minutes to learn the game and a lifetime to master"
"Share your knowledge. It's a way to achieve immortality."

TomThomson SSC Guru Points: 104773 More actions · Answer 6

I must be going insane - checked both for sql 20012 and both for sql 2008 R2, and then checked sql 2008 standard instead of sql 2008 enterprise! Not finger trouble, definite brain failure! Knew it as soon as I hit submit, before the website responded.

edit: looks as if some people have picked a less than 5 options, despite the clear instructions.

Tom

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 7

Easy question but I have to learn to read. I picked the one that it wouldn't work on not the 5 it would. I guess I thought logically that would be the sensible way to ask the question. Oh well?

kapfundestanley SSCertifiable Points: 5637 More actions · Answer 8

A nice and easy one for me ,thanx

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

honza.mf SSCertifiable Points: 5519 More actions · Answer 9

Omit the "(Choose 5)" advice and the number of correct answers fall down (including me) 😉

Thomas Abraham SSChampion Points: 10761 More actions · Answer 10

(Bob Brown) (7/31/2012)
Easy question but I have to learn to read. I picked the one that it wouldn't work on not the 5 it would. I guess I thought logically that would be the sensible way to ask the question. Oh well?

Got it right, but agree that picking the one that doesn't allow compression makes more sense than selecting the 5 that do allow it. Other than that, a nice question. Thanks.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Toreador SSChampion Points: 11368 More actions · Answer 11

Figured they wouldn't remove functionality from a later release so guessed right 🙂

Luis Cazares SSC Guru Points: 183706 More actions · Answer 12

L' Eomot Inversé (7/31/2012)
edit: looks as if some people have picked a less than 5 options, despite the clear instructions.

I never read the "choose 5" instruction until I saw your comment.

However I new compression was available for backup since 2008 for Enterprise and 2008 R2 for versions Standard and higher, I just guessed on 2012 because it seemed obvious.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

lbrigham SSCommitted Points: 1567 More actions · Answer 13

Thanks for input, everyone.

Thomas Abraham (7/31/2012)
(Bob Brown) (7/31/2012)
Easy question but I have to learn to read. I picked the one that it wouldn't work on not the 5 it would. I guess I thought logically that would be the sensible way to ask the question. Oh well?
Got it right, but agree that picking the one that doesn't allow compression makes more sense than selecting the 5 that do allow it. Other than that, a nice question. Thanks.

The purpose of the question was to reinforce the fact that Microsoft introduced backup compression for SQL Standard edition starting with 2008 R2. I thought about asking the question that way, but concluded that made the question too easy and it's already somewhat easy as is.