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 12»»

Replication Expand / Collapse
Author
Message
Posted Tuesday, May 11, 2010 9:45 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, May 10, 2010 11:23 PM
Points: 262, Visits: 53
Comments posted to this topic are about the item Replication
Post #920150
Posted Tuesday, May 11, 2010 9:46 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, November 21, 2014 8:52 AM
Points: 271, Visits: 386
Answer is SQL 2008, but what is it http://technet.microsoft.com/en-us/library/ms151196%28SQL.90%29.aspx ?

SQL Server 2005 Books Online (November 2008)
Peer-to-Peer Transactional Replication
Post #920151
Posted Tuesday, May 11, 2010 10:17 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, November 2, 2014 11:03 PM
Points: 2,103, Visits: 371
good question... didn't know about this... but was wondering has anybody implemented this peer stuff in their organisation and how does it perform vis-a-vis the existing systems ?
Post #920157
Posted Wednesday, May 12, 2010 12:00 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 8:49 PM
Points: 17,967, Visits: 15,979
In the very same document that is used as a source there is reference to using 2005 in Peer to Peer replication.

Also when searching on the topic, the MS edition comparison shows both 2008 editions as supported. The following also states that peer to peer is supported in both 2008 editions.
http://searchsystemschannel.techtarget.com/tip/0,289483,sid99_gci1330304,00.html




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #920189
Posted Wednesday, May 12, 2010 2:31 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 2:31 AM
Points: 1,109, Visits: 306
I do find it quite funny that though the question asks 'which edition of SQL Server 2008...' at least 30 people think the correct edition of SQL2008 is 'Sql Server 2005 Enterprise edition'



-------------------------------
Oh no!
Post #920243
Posted Wednesday, May 12, 2010 3:13 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
Hi,

peer to peer replication is exists in sql 2005. please check these..

http://www.sql-server-performance.com/articles/dba/peer-to-peer_replication_p1.aspx
http://msdn.microsoft.com/en-us/library/ms152536.aspx

question is good, but presented badly.


Thanks
VinaY




Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #920275
Posted Wednesday, May 12, 2010 5:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 8, 2014 12:19 PM
Points: 105, Visits: 26
Also supported in Datacenter Edition in 2008 R2.

http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.105).aspx
Post #920370
Posted Wednesday, May 12, 2010 6:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 20, 2010 2:04 PM
Points: 46, Visits: 13
http://technet.microsoft.com/en-us/library/ms151196(SQL.90).aspx
I want my points ... that's my points
however ... good subject question: I don't know anything about that
Post #920394
Posted Wednesday, May 12, 2010 6:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 13, 2012 9:57 AM
Points: 15, Visits: 90
According to msdn it is supported in SQL Server Enterprise 2005

"Peer-to-peer replication is available only in SQL Server 2005 Enterprise Edition."

http://msdn.microsoft.com/en-us/library/ms151196(SQL.90).aspx
Post #920418
Posted Wednesday, May 12, 2010 7:25 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 9:33 PM
Points: 1,359, Visits: 1,728
send2vic (5/12/2010)
According to msdn it is supported in SQL Server Enterprise 2005

"Peer-to-peer replication is available only in SQL Server 2005 Enterprise Edition."

http://msdn.microsoft.com/en-us/library/ms151196(SQL.90).aspx


This is true. But since the question asked which edition of SQL Server 2008 supported it, it's irrelevant.

The question was good, but had a minor flaw in presentation. Because it was single-choice, and the two relevant choices were Standard and Enterprise edition, all that was required to get a correct answer was the knowledge that Enterprise edition has all of the features of Standard edition and more. Therefore if Standard edition were a correct answer, then Enterprise edition would have to be as well. And if Standard edition were not correct, Enterprise is the only other option. So Enterprise edition has to be a correct answer.

So if you really want to test someone's knowledge of features in specific editions, a multiple-answer format really is necessary.
Post #920451
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse