SQL Server Performance Forum – Threads Archive
LogShipping to A ClusterHas 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. Thks
Check: http://www.sql-server-performance.com/clustering_resources.asp Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
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.