Results 1 to 3 of 3

Thread: SQL replication-zilla

  1. Aug 1st, 2007, 04:02 PM #1
    JPicasso
    JPicasso is offline

    Thread Starter
    Fanatic Member JPicasso's Avatar
    Join Date
    Aug 2001
    Location
    Kalamazoo, MI
    Posts
    843

    SQL replication-zilla

    I just got brought onto a project that is having issues with SQL Server 2005
    replicating out to 2000+ machines.
    That seems like a lot.
    We are using merge replication.

    The plan is to move the databases to another SQL Server on a heftier machine.
    Has anyone had any "gotchas" doing this type of move?
    Merry Christmas
    Reply With Quote Reply With Quote
  2. Aug 2nd, 2007, 05:49 AM #2
    Blade
    Blade is offline
    Fanatic Member Blade's Avatar
    Join Date
    Jan 1999
    Location
    Stoke-on-Trent, UK
    Posts
    527

    Re: SQL replication-zilla

    How many distributors do you have and how many agents?

    2000+ subscribers does seem a lot, do you have any latency problems at the moment? Certainly the beefier box the more you could push through with less latency.
    Reply With Quote Reply With Quote
  3. Aug 3rd, 2007, 12:41 PM #3
    JPicasso
    JPicasso is offline

    Thread Starter
    Fanatic Member JPicasso's Avatar
    Join Date
    Aug 2001
    Location
    Kalamazoo, MI
    Posts
    843

    Re: SQL replication-zilla

    We have 8 merge agents. We are only having any trouble with our largest.
    It starts to work for a day or so, then just gives up.

    There is only one distributor, the same machine that is the publisher.
    Merry Christmas
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width