Redundancy Question

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Julie (anonymous_at_discussions.microsoft.com)
Date: 05/19/04 

Date: Wed, 19 May 2004 03:01:25 -0700

Have you looked at Replication yet ?

With this you can automatically copy information for one
database to another automatically.

Look up Snapshot and Transactional Replication.

J

>-----Original Message-----
>Dear All
>
>We have a server running Windows 2000 Server with SQL
2000. This is our web
>server, and what I would like to do is implement some
form of redundancy
>server within this environment. Ideally, what I would
like to achieve is a
>scenario where is if there is a failure on one of the
servers another one
>would start up ad take on the exact same role with the
exact same access and
>sql database and applications.
>
>Does anyone have any idea how this would be achieved, and
point in the right
>direction.
>
>Thanks
>
>Neil
>
>
>.
>

Relevant Pages

  • Re: Replication between instances
    ... Looking for a SQL Server replication book? ... "Rory P" wrote in message ... > we are looking to doing a transactional replication of a database of 12 ... > We want to do this so we can have a read database and a write database. ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge versus Two Way, Bidirectional Transactional Replication
    ... backup server. ... I have been considering both merge and transactional replication, ... My biggest problem is that I cannot modify the database schema once the ...
    (microsoft.public.sqlserver.replication)
  • Re: balancing connections - any idea ?
    ... system as it reduce the shared locks on main SQL server table. ... You can use two node active/active cluster and divide the database ... 3).u can implement transactional replication of important table and then ... to peer transactional replication splitting connections and replicating ...
    (microsoft.public.sqlserver.clustering)
  • Re: Help in setting up SQL Server 2005 Replication
    ... The reason i wanted to chose transactional replication with updatable ... active database as it is a push/pull situation. ... bi-directional transactional replication may be a better fit. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: newbie in replication
    ... Transactional replication should work as long as the tables are identical on ... DML operation on the publisher/security database. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)