Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Snapshots Expand / Collapse
Author
Message
Posted Saturday, July 25, 2009 2:17 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 11:27 AM
Points: 2,670, Visits: 783
Comments posted to this topic are about the item Snapshots

Jamie
Post #759688
Posted Sunday, July 26, 2009 1:36 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 24, 2013 1:57 PM
Points: 211, Visits: 72
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).
Post #759804
Posted Sunday, July 26, 2009 2:04 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 11:27 AM
Points: 2,670, Visits: 783
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
Post #759809
Posted Monday, July 27, 2009 4:30 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 24, 2013 1:57 PM
Points: 211, Visits: 72
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.
Post #759950
Posted Monday, July 27, 2009 6:02 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 4:12 PM
Points: 2,007, Visits: 768
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
Post #759979
Posted Monday, July 27, 2009 7:50 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:55 PM
Points: 31,278, Visits: 15,736
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
Post #760058
Posted Saturday, August 8, 2009 9:28 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 2:56 AM
Points: 2,624, Visits: 581
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
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
Post #767412
Posted Monday, November 23, 2009 10:29 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, January 11, 2013 12:41 PM
Points: 621, Visits: 297
Hey I knew that.



Bhavesh Patel

http://bhaveshgpatel.wordpress.com/
Post #823644
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse