SQL Server 2000 /Merge Replication General Question

Discussion in 'microsoft.public.sqlserver.replication' started by mazda_88, Oct 16, 2003.

  1. mazda_88

    mazda_88 Guest

    We have a requirement to ensure that our web sites are always up and
    available. We have a pretty basic architecture using 2 webservers
    accessing a SQL Server backend. This architecuture exists on 2
    separate web hosting facilities (located hundreds of miles from each
    other). We will call the system in web hosting facility 1, system 1
    and the system in web hosting 2, system 2. It is currently setup so
    that if system 1 goes down, individuals are redirected to system 2.
    In the current setup, system 2 does not support database updates. The
    user can only view the data.

    We now have a requirement for system 2 to support database updates.
    In order to accomplish this we plan on using merge replications.

    Question.

    Should you have a publisher on one box, and a subscriber on each
    system or can you have the publisher on system 1, and a subscriber on
    system 2.

    If you can have the later, what happens if system 1 needs to be
    rebuilt. Can the subscriber on system 2 become the publisher.

    Is there another way of implementing this redundancy.

    Thanks,
     
    mazda_88, Oct 16, 2003
    #1
    1. Advertisements

  2. You can configure your System1 as the publisher.
    Add System2 as a global subscriber to System1.
    Now System1 and System2 will be synching, and you can make updates at either
    System1 or System2.

    Additionally conficure the System 2 as a republisher. ( You can find
    information in Books On Line)
    Making System 2 as a republisher, will allow new subscribers to be
    configured from System2. System2 will act as a publisher for these new
    subscribers

    So in case, System1 gets corrupt, or for whatever reasons you need to
    rebuild, then you can rebuild System1, cleanup up System2 of traces of
    System1, add System1 as a subscriber of System2 and sync data.

    Hope that helps.
    --Mahesh

    This posting is provided "as is" with no warranties and confers no rights.
     
    Mahesh [MSFT], Oct 20, 2003
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.