Restoring Editions

Question

Restoring Editions

Viewing 15 posts - 16 through 30 (of 56 total)

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

michael.kaufmann SSCrazy Points: 2816 More actions · Answer 1

jadsmith (5/6/2011)
It would depend on if the database backed up contains Enterprise features or not. If not the backup should restore with no problems. The question doesn't say that there are such features used in the database.
The books online page http://msdn.microsoft.com/en-us/library/bb964719.aspx indicates that every edition of sql server 2008 can restore a compressed backup, though only 2008 Enterprise or 2008R2 Standard and higher can create the compressed backup

Not having worked with Enterprise only features, I haven't encountered any issues yet.

Plus the following MS article also let's one assume that the restore will succeed without any limitations:

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

But I'd assume that Steve has better knowledge and probably knows from first hand experience.

Thanks for the question and the learning.

Michael

Gristley SSCommitted Points: 1595 More actions · Answer 2

Yes you can!

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

The question neglected to mention any enterprise specific elements bring present, as a result the answer should be YES.

Trevor.

Chris Houghton SSCrazy Points: 2557 More actions · Answer 3

Trevor Tinsley (5/6/2011)
Yes you can!
http://technet.microsoft.com/en-us/library/bb964719.aspx
The question neglected to mention any enterprise specific elements bring present, as a result the answer should be YES.
Trevor.

The question explicitly mentions data compression which is an Enterprise only feature. Therefore the restore would fail.

tommyh SSCertifiable Points: 6302 More actions · Answer 4

Trevor Tinsley (5/6/2011)
Yes you can!
http://technet.microsoft.com/en-us/library/bb964719.aspx
The question neglected to mention any enterprise specific elements bring present, as a result the answer should be YES.
Trevor.

As a response to this and to michael.kaufmann. The question wasnt about backup compression but data compression... its not the same thing. And data compression is an Enterprise feature.

http://msdn.microsoft.com/en-us/library/dd894051%28v=sql.100%29.aspx for a bit of info about data compression.

/T

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

Really tough question, no wonder only 9 % got it right

M&M

Ernie Schlangen SSCrazy Points: 2382 More actions · Answer 6

jadsmith (5/6/2011)
It would depend on if the database backed up contains Enterprise features or not. If not the backup should restore with no problems. The question doesn't say that there are such features used in the database.
The books online page http://msdn.microsoft.com/en-us/library/bb964719.aspx indicates that every edition of sql server 2008 can restore a compressed backup, though only 2008 Enterprise or 2008R2 Standard and higher can create the compressed backup

I second this post. The correct answer cannot be determined from the question as written.

Edit:

D'oh! Should have read the rest of the posts before commenting....

paul.knibbs SSCoach Points: 15320 More actions · Answer 7

I second this post. The correct answer cannot be determined from the question as written.

Yes it can, because the question as written is talking about "data compression", NOT "backup compression".

WadeN 75975 SSC Enthusiast Points: 121 More actions · Answer 8

So...none of the 4 answers are completely correct, altho the 4th one is closest. Would this then be the correct answer: "The restore will copy all the data from the backup file and then MAY fail" ?

1st.hero SSC Rookie Points: 26 More actions · Answer 9

check this site

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

WadeN 75975 SSC Enthusiast Points: 121 More actions · Answer 10

Found some more info...compression does appear to be available only in Enterprise Edition (and Developer Edition). Here's an article on how to restore an Enterprise level database with compression to a lower level edition:

http://blogs.msdn.com/b/sqlserverfaq/archive/2010/09/03/how-to-identify-compressed-tables-before-restoring-migrating-database-to-any-edition-other-than-enterprise-edition-of-sql-server-2008.aspx

michael.kaufmann SSCrazy Points: 2816 More actions · Answer 11

tommyh (5/6/2011)
As a response to this and to michael.kaufmann. The question wasnt about backup compression but data compression... its not the same thing. And data compression is an Enterprise feature.
http://msdn.microsoft.com/en-us/library/dd894051%28v=sql.100%29.aspx for a bit of info about data compression.
/T

Tommy,

thanks for the clarification--reading slowlier would actually help, I guess... :Whistling:

Just remembered 'backup' and 'compression' when attempted my answer--and missed the 'data' in between.

Regards,

Michael

Brigadur SSCrazy Points: 2097 More actions · Answer 12

Great question! I had the wrong answer, but learned something today 🙂

Cheers

mtassin SSC-Insane Points: 23099 More actions · Answer 13

Chris Houghton (5/6/2011)
Good question. I rushed it and misread "data" compression as "backup compression" so I selected that it would succeed. Haste makes waste.

Same here... ah well

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

Meet George Jetson SSChampion Points: 11627 More actions · Answer 14

In a rush and managed to miss the all important Enterprise feature of "data compression." RTFS

Good question

Chris Powell

George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 15

paul s-306273 (5/6/2011)
Nice question Steve.
What do you think about the %age of correct answers?

I think that this is an item that very few people have thought about, or experienced. I think there were a lot of people that read "compression" and assumed backup compression, not data compression.