Replication

Question

Post reply

Replication

Ali Asghar Sharifi

Mr or Mrs. 500

Points: 526
More actions
May 11, 2010 at 9:45 pm

#218797

Comments posted to this topic are about the item Replication

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

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

natalie.ignatieva SSChasing Mays Points: 622 More actions · Answer 1

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

ziangij SSCertifiable Points: 7985 More actions · Answer 2

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 ?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

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

Kevin Gill SSCrazy Points: 2348 More actions · Answer 4

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!

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 5

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

SweeneyGIS SSC Enthusiast Points: 131 More actions · Answer 6

Also supported in Datacenter Edition in 2008 R2.

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

gameplayeur SSC Journeyman Points: 80 More actions · Answer 7

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

send2vic SSC Rookie Points: 27 More actions · Answer 8

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

sknox SSChampion Points: 12388 More actions · Answer 9

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.

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 10

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.

natalie.ignatieva SSChasing Mays Points: 622 More actions · Answer 11

natalie.ignatieva

SSChasing Mays

Points: 622

May 12, 2010 at 8:13 am

#1166238

I want my point 🙂

bradfield_eric Valued Member Points: 56 More actions · Answer 12

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.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

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

UMG Developer SSChampion Points: 13482 More actions · Answer 14

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.