Replication

  • Comments posted to this topic are about the item Replication

  • 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

  • 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 ?

  • 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[/url]
    Learn Extended Events

  • 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!

  • 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 !!!

  • Also supported in Datacenter Edition in 2008 R2.

    http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.105).aspx

  • 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

  • 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

  • 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.

  • The question has been edited to remove the 2005 choice. It does ask which version of 2008, so that's not a valid answer, but in hindsight that's a little tricky.

  • I want my point 🙂

  • I would have to agree that the question could have been worded better. But I think it still encouraged people to think a little about replication, how it works, what options are available, and most importantly, which editions of SQL Server each type of replication is available in.

  • Steve Jones - Editor (5/12/2010)


    The question has been edited to remove the 2005 choice. It does ask which version of 2008, so that's not a valid answer, but in hindsight that's a little tricky.

    I think the tricky part of the question is that two editions of SQL 2008 support this feature. The source for the answer is reliant on one statement in an msdn article that contradicts itself further down in the article.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • sknox (5/12/2010)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.

    This is actually what I was thinking, that Enterprise had to support it, so there was really no choice.

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply