November 19, 2004 at 2:40 pm
Is it possible to update or replicate by means of broadcasting in sql server 2000? My servers are in the same LAN. Objective is to reduce the network traffic. Instead of replicating to one server at a time I want to update all servers at once.
As I understand, at Eithernet level, IP Address, aaa.bbb.ccc.255 is a broadcast message to all servers. Can SQL server use this feature to broadcast the updates?
How, if possible?
Munzer
November 19, 2004 at 4:01 pm
Also posted in your other topic which included this question later.
No you technically cannot. However you could build a middle tier service to update to multiple locations at one time with transactions so you can recover from a failure. Or I have seen a few products that say they can do this for you. That is nothing inside SQL that will directly do this.
November 20, 2004 at 11:54 am
Antatres686,
Why basic replication to several sql servers (in a single LAN) via broadcasting is not supported?
Is it because of
1) technical/logical impossibility OR
2) Technological difficulties OR
3) oversight in Microsoft's part.
I need to copy bunch of large tables from one sql server to multiple sql servers within a LAN periodically. We know Ethernet supports boradcasting.
As we know, even when SQL server replicate to a specific server, ethernet hub broadcast this to all other servers in the same LAN anyway. Other servers drop the packet since it is not addressed to them. Hub's broadcasting in a LAN hog the ethernet buss. No other machine in the LAN can talk during that time. Therefore, why not use the ethernet's broadcasting to update multiple servers at the same time? Replication by broadcasting would have saved me a lot of LAN-bandwidth.
Munzer
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply