SQL Server Performance

LogShipping to A Cluster

Discussion in 'SQL Server Log Shipping' started by mrbrew5510, Jan 15, 2004.

  1. mrbrew5510 New Member

    Has anyone any advice or experience in logshipping from a cluster to another cluster?

    Are there any pitfalls to doing this.

    I have implemented logshipping in other configuration but never as this and had heard someone say that this was not a recommeded practice.

    Please advise.

  2. Luis Martin Moderator

  3. satya Moderator

    For the log shipping part refer to this linkhttp://www.sql-server-performance.com/sql_server_log_shipping.asp

    You can use both, but it depends on what you want to do. To create an offsite standby, it is always best to use log shipping. Replication is best used in certain scenarios.

    There should not be any problems - I have done both and it works just fine. However, you should never make your copy directory local to a node; you should make an intermediate directory so that the TLs are accessible to all nodes.

    Clustering gives you automatic failover and is considered more of a 'hot' standby. Log shipping failover is manual but is more loosely coupled.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page