Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2005-07-26 : 03:13:18
|
| I'm a bit confused about Log Shipping and Clustering. I've looked at some of the information in BOL and as far as I can see Log Shipping is essentially a SQL equivalent of Clustering (though they both have their own advantages and disadvantages)My question is this. Under what circumstances might you want to use one in preference to the other and are there any circumstances where you may want to use both at the same time?thankssteveAlright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer. |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-07-26 : 05:22:13
|
| From my point of view Log shipping is a way to keep the destination db synchronized with the source db. That's all.If that's what you need, fine.SQL Server 2000 failover clustering provides high availability support and also multiple instances.During an operating system failure or planned os upgrade, your instance fail over to any other node in the failover cluster configuration.In this way, you minimize system downtime.Costs can be very different.Franco |
 |
|
|
|
|
|
Cluster Shipping