<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Steve Jones
»
Restoring Editions
57 posts, Page 1 of 6
1
2
3
4
5
»
»»
Restoring Editions
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Thursday, May 05, 2011 9:55 PM
SSC-Dedicated
Group: Administrators
Last Login: Yesterday @ 3:26 PM
Points: 31,425,
Visits: 13,738
Comments posted to this topic are about the item
Restoring Editions
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1104312
free_mascot
free_mascot
Posted Thursday, May 05, 2011 11:41 PM
SSCommitted
Group: General Forum Members
Last Login: Wednesday, April 17, 2013 3:39 AM
Points: 1,768,
Visits: 1,312
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."
Post #1104323
tommyh
tommyh
Posted Thursday, May 05, 2011 11:47 PM
UDP Broadcaster
Group: General Forum Members
Last Login: Friday, May 10, 2013 3:15 AM
Points: 1,476,
Visits: 1,943
What the **** was Microsoft thinking here... ah thats right they wherent thinking as usual... sigh.
Great question though, definatly worth knowing.
/T
Post #1104324
honza.mf
honza.mf
Posted Thursday, May 05, 2011 11:56 PM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 4:05 AM
Points: 1,103,
Visits: 1,199
20 optimists now.
See, understand, learn, try, use efficient
© Dr.Plch
Post #1104326
tommyh
tommyh
Posted Friday, May 06, 2011 12:19 AM
UDP Broadcaster
Group: General Forum Members
Last Login: Friday, May 10, 2013 3:15 AM
Points: 1,476,
Visits: 1,943
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?
/T
Post #1104330
honza.mf
honza.mf
Posted Friday, May 06, 2011 12:58 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 4:05 AM
Points: 1,103,
Visits: 1,199
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?
/T
Optimist is a person, who has insufficient information
See, understand, learn, try, use efficient
© Dr.Plch
Post #1104341
tommyh
tommyh
Posted Friday, May 06, 2011 1:00 AM
UDP Broadcaster
Group: General Forum Members
Last Login: Friday, May 10, 2013 3:15 AM
Points: 1,476,
Visits: 1,943
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?
/T
Optimist is a person, who has insufficient information
That i like
/T
Post #1104342
Koen Verbeeck
Koen Verbeeck
Posted Friday, May 06, 2011 1:01 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 6:39 AM
Points: 9,376,
Visits: 6,472
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?
/T
A pessimist is an optimist with experience
Anyway, nice question. Good to know.
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1104343
jadsmith
jadsmith
Posted Friday, May 06, 2011 1:07 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 2:43 AM
Points: 2,778,
Visits: 471
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
Post #1104346
tommyh
tommyh
Posted Friday, May 06, 2011 1:12 AM
UDP Broadcaster
Group: General Forum Members
Last Login: Friday, May 10, 2013 3:15 AM
Points: 1,476,
Visits: 1,943
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
Post #1104349
« Prev Topic
|
Next Topic »
57 posts, Page 1 of 6
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
