May 5, 2011 at 9:55 pm
Comments posted to this topic are about the item Restoring Editions
May 5, 2011 at 11:41 pm
Got incorrect.
But thank you for nice question. New learning.
SQLSKILLS Link is super and my favourite site too.
Cheer!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 5, 2011 at 11:47 pm
What the **** was Microsoft thinking here... ah thats right they wherent thinking as usual... sigh.
Great question though, definatly worth knowing.
/T
May 5, 2011 at 11:56 pm
20 optimists now.
May 6, 2011 at 12:19 am
honza.mf (5/5/2011)
20 optimists now.
Hrmmm... in this case whats an optimist. One that thinks it will work or one that thinks it will fail at once... or both? :unsure:
/T
May 6, 2011 at 12:58 am
tommyh (5/6/2011)
Hrmmm... in this case whats an optimist. One that thinks it will work or one that thinks it will fail at once... or both? :unsure:/T
Optimist is a person, who has insufficient information :w00t:
May 6, 2011 at 1:00 am
honza.mf (5/6/2011)
tommyh (5/6/2011)
Hrmmm... in this case whats an optimist. One that thinks it will work or one that thinks it will fail at once... or both? :unsure:/T
Optimist is a person, who has insufficient information :w00t:
That i like 😀
/T
May 6, 2011 at 1:01 am
tommyh (5/6/2011)
honza.mf (5/5/2011)
20 optimists now.Hrmmm... in this case whats an optimist. One that thinks it will work or one that thinks it will fail at once... or both? :unsure:
/T
A pessimist is an optimist with experience 😀
Anyway, nice question. Good to know.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 6, 2011 at 1:07 am
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
May 6, 2011 at 1:12 am
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 have a backup taken from a SQL Server 2008 Enterprise Edition database that uses data compression". Doesnt say backup compression. But i can see where one could interpret this both ways.
/T
May 6, 2011 at 1:23 am
Koen Verbeeck (5/6/2011)
tommyh (5/6/2011)
honza.mf (5/5/2011)
20 optimists now.Hrmmm... in this case whats an optimist. One that thinks it will work or one that thinks it will fail at once... or both? :unsure:
/T
Why so serious?
Am I? 😀
May 6, 2011 at 1:44 am
Got it wrong, but that's because I selected what I thought would be the logical thing to happen when restoring a database with unsupported features--it's not something I've ever actually tried!
May 6, 2011 at 2:40 am
Nice question Steve.
What do you think about the %age of correct answers?
May 6, 2011 at 2:51 am
Good question. I rushed it and misread "data" compression as "backup compression" so I selected that it would succeed. Haste makes waste.
May 6, 2011 at 2:56 am
Interesting question, got it wrong thinking it would fail immediately! Have voted on Connect to ask them to make it so.
Viewing 15 posts - 1 through 15 (of 56 total)
You must be logged in to reply to this topic. Login to reply