help pls

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Experts,



I am new in this area and no nothing abt replication so.. i need your advise
pls. we need to setup replication between 2 server. Our requirement is



1. Any database changes that happens in server 1 databases must be
replicated to Server 2 and vice-versa.

2. People from L1 connect to Server 1 only and l2 connect to server 2.
But If server 1 goes down then server 2 should be able to handle the user
request and vice-versa.

3. Data integrity must be maintained



What he got



2 Power full server

100 Mg Ethernet direct link, our network delay is bit high..

SQL 2008 Std edition





What would be the ideal replication method to satisfy our need

Do I have to backup the server separately



Thanks

vinu














.

Relevant Pages

  • Re: SBS 2003 and Replication Errors with Remote DC
    ... I just promoted the remote DC last week, so I still have time to solve the replication issues. ... Domain Controller Diagnosis ... Connecting to directory service on server alpha. ... Performing upstream analysis. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Replication Errors with Remote DC
    ... alpha server as soon as you can to get things going. ... A simple DNS replication test is to create a host record in the SBS server ... Domain Controller Diagnosis ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Replication Errors with Remote DC
    ... I did make the changes that you suggested on the DNS of my alpha server and rebooted. ... I did run the simple DNS test that you suggested by adding a host record to my SBS server. ... A simple DNS replication test is to create a host record in the SBS server and wait till it shows up in the remote server. ...
    (microsoft.public.windows.server.sbs)
  • Re: Unable to decommission a Windows 2008 DC via dcpromo
    ... Can you open and compare sysvol and netlogon share on both DCs? ... Verifying that the local machine server2, ... The File Replication Service Event log test ... Latency information for 8 entries in the vector were ...
    (microsoft.public.windows.server.active_directory)
  • Re: adding 64-bit R2 DC to existing domain
    ... Server 2003 standard edition 32-bit domain controllers. ... The schema master did not complete a replication cycle ..." ... server1 failed test KnowsOfRoleHolders ... ForestDnsZones failed test CrossRefValidation ...
    (microsoft.public.windows.server.setup)