SQL Server Performance

one primary server and two secondary server

Discussion in 'SQL Server 2005 Log Shipping' started by nagaraj, Aug 7, 2007.

  1. nagaraj New Member

    Hi,
    Is it possible to make one primary server and two secondary servers
    and vice versa
    four primary servers and one secondary server.
    pl.
  2. satya Moderator

    Using what, database mirroring or log shipping?
    It is possible but you have to perform manual failover when it comes to a failure with a current primiary server.
  3. nagaraj New Member

    using log shipping.
    thanks for the info.
  4. ghemant Moderator

    HI,
    Yes it is possible to have two secondary servers, we have similar setup in log shipping, where one database is shipped to two different servers. But we haven't any setup ( haven't tried it) vice versa.
  5. satya Moderator

    As referred by Hemant it is possible to have 1 primary to 2 secondary servers.
    four primary servers and one secondary server.
    This is also possible provided you are prepared to accept single-point of failure in case you need to invoke the primary-secondary scenario. Also that Secondary server should be well eqiupped with resources in order to cater the 4 primary servers log transactions.

Share This Page