Post reply

replicate/update by multicasting or broadcasting

  • December 8, 2004 at 2:09 pm

    #86109

    I have 4 sql server machines connected to a single switch (single network).

    How can one of the above sql server update a record in 2 of the 3 servers by multicasting or broadcasting? To keep the network traffic to a minimum I do not want to update one server at a time.

    IP protocol has built in mechanism for multicasting and broadcasting, therfore, SQL server should be able to take the advantage of it. I do not know if it does.

    Munzer Haque

  • December 13, 2004 at 10:36 am

    #533591

    There is no support for multicasting and broadcasting in SQL server. Something could be implemented probably on OS level. Anyway, if you want to "broadcast" updates from one SQL server to others - you can use distributed queries or transactional replication (it has some network advantages in comparition with other replication types).

Viewing 2 posts - 1 through 2 (of 2 total)

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