Replication

Question

Replication

free_mascot

One Orange Chip

Points: 27169
More actions
April 3, 2014 at 8:58 pm

#306306

Comments posted to this topic are about the item Replication
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 4, 2014 at 2:45 am

This was removed by the editor as SPAM

Viewing 12 posts - 1 through 11 (of 11 total)

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Nice question to end the week, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

radek.hruby SSCrazy Points: 2123 More actions · Answer 2

Here is the article you (probably) were looking for: http://technet.microsoft.com/en-us/library/ms183524.aspx

free_mascot One Orange Chip Points: 27169 More actions · Answer 3

radek.hruby (4/4/2014)
Here is the article you (probably) were looking for: http://technet.microsoft.com/en-us/library/ms183524.aspx

Appreciate your help to find out this link.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

free_mascot One Orange Chip Points: 27169 More actions · Answer 4

radek.hruby (4/4/2014)
Here is the article you (probably) were looking for: http://technet.microsoft.com/en-us/library/ms183524.aspx

Appreciate your help to find out this link.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Ed Wagner SSC Guru Points: 287026 More actions · Answer 5

free_mascot (4/4/2014)
radek.hruby (4/4/2014)
Here is the article you (probably) were looking for: http://technet.microsoft.com/en-us/library/ms183524.aspx
Appreciate your help to find out this link.

Nice way to end the week. Everyone have a good weekend.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Stewart "Arturius" Campbell (4/4/2014)
Interesting question, thanks.
I have never found the need to have more than one distributor per instance of SQL server, but good to know that it is possible

I have seen deadlocks in the distribution database. This is where I think multiple distribution dbs would be most helpful - a means to help reduce activity in any one distribution db and reduce the chances for deadlocks.

Otherwise, one distribution db is usually sufficient enough.

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

Dana Medley SSCertifiable Points: 6764 More actions · Answer 7

Great question, thanks. I've also found another article here http://www.sqlservercentral.com/articles/Replication/69663/ mentioning benefits/how to's on multiple distribution databases. Have a great weekend!

Everything is awesome!

Hany Helmy SSChampion Points: 13921 More actions · Answer 8

Stewart "Arturius" Campbell (4/4/2014)
Interesting question, thanks.
I have never found the need to have more than one distributor per instance of SQL server, but good to know that it is possible.
radek.hruby (4/4/2014)
Here is the article you (probably) were looking for: http://technet.microsoft.com/en-us/library/ms183524.aspx
Thanks for this link...

Thanx +1

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 9

Good question thanks.

Hope this helps...

Ford Fairlane
Rock and Roll Detective

TomThomson SSC Guru Points: 104773 More actions · Answer 10

Good question. Potentially useful to know this.

Tom