SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Snapshots


Snapshots

Author
Message
Jamie-2229
Jamie-2229
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3127 Visits: 836
Comments posted to this topic are about the item Snapshots

Jamie
red_serene
red_serene
SSC Veteran
SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)

Group: General Forum Members
Points: 215 Visits: 74
http://msdn.microsoft.com/en-us/library/cc645993.aspx
I believe that the answer to this topic is incorrect. Per the above URL for sql2008, both Enterprise and Standard editions support Snapshot Replication. As Developer and Enterprise editions support the same feature sets, it would not make sense to select that choice as it would not cover the Standard edition. Therefore I believe that my answer is correct (Dev + Std). Another alternative would have been Standard, Enterprise, and Developer editions (which would have been the best answer).
Jamie-2229
Jamie-2229
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3127 Visits: 836
http://www.sharepointblogs.com/wsspectacular/archive/2009/03/10/sql-2008-annoyances.aspx

Part of what this question attempts to point out is there is a long list of features available in the Enterprise version NOT available in the Standard version.

The CIO would probably understand if it was explained in terms of Cost Per Processor. As the Enterprise version costs roughly ten times that of the Standard, it is pretty obvious here that what you purchase from Microsoft with the Enterprise version are its features.

Microsoft provides the Developer with an Enterprise version, but it is not licensed in the same manner. So while technically, you could create a snapshot by writing a backup of the server each day to your laptop, and then publishing the snapshot, it sort of defeats the purpose of having a snapshot readily available.

Jamie
red_serene
red_serene
SSC Veteran
SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)

Group: General Forum Members
Points: 215 Visits: 74
It is unfortunate that the question did not mention anything about cost or licensing, but only what was possible. Snapshot replication *is* possible with Standard edition, which is why I questioned the resultant answer. It may have been better to focus on a different feature that really was NOT available in Standard edition if that was to be the focus of the question.
Noel McKinney
Noel McKinney
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2073 Visits: 798
red_serene (7/26/2009)
http://msdn.microsoft.com/en-us/library/cc645993.aspx
I believe that the answer to this topic is incorrect. Per the above URL for sql2008, both Enterprise and Standard editions support Snapshot Replication. As Developer and Enterprise editions support the same feature sets, it would not make sense to select that choice as it would not cover the Standard edition. Therefore I believe that my answer is correct (Dev + Std). Another alternative would have been Standard, Enterprise, and Developer editions (which would have been the best answer).

Snapshot replication and database snapshots are not the same. If you look at your link under High Availability you will see that "Database snapshots" are only available for Enterprise. Below is the BOL link for more information on database snapshots (which also mentions that this is a feature only available in Enterprise edition).

http://msdn.microsoft.com/en-us/library/ms175158.aspx
Steve Jones
Steve Jones
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: Administrators
Points: 61675 Visits: 19099
The question was for database snapshots, not snapshot replication, but I can see where the confusion would lie. I have never heard a replication snapshot called a "snapshot of xxx database", but perhaps people do call it that.

I have reworded the question, and added a link to the database snapshot item in BOL.

I will also award back points.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
hakan.winther
hakan.winther
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2826 Visits: 605
It is really nice to have a developer edition with all the features that exists in Enterprice, but it is too easy to build a database solution that is not supported by the production server if it is another version then Enterprice.

/Håkan Winther
MCITPBigGrinatabase Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
Bhavesh_Patel
Bhavesh_Patel
Say Hey Kid
Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)

Group: General Forum Members
Points: 677 Visits: 297
Hey I knew that.



Bhavesh Patel

http://bhaveshgpatel.wordpress.com/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search