Log Shipping vs Replication

[DBAWinnipeg]

Does anyone have any good info/links regarding the pros and cons of Log Shipping vs Replication (Snapshot, Transactional, Merge) ?

Any help would be greatly appreciated.


Thanks in advance!!!

Colin in da 'Peg

 

[JayKusch]

3) Log Shipping

Offers hardware, OS, software, and data fault tolerance (assuming two servers, primary and hot spare)

High reliability

Potential for some lost data (time between log backups).

Transaction consistency is not guaranteed.

Manual failover

Switchover is often 1+ hours

Lower Cost

4) Replication

Designed for data, not for schema modifications, because of this, hard to implement for stand-by server

Replication is unreliable

Manual failover

Potential for minimal lost data (time between transactions).

Transaction consistency is not guaranteed.

Switchover is often 1+ hours or more

Lower Cost


Thanks

J. Kusch

 

[DBAWinnipeg]

Are there any positives to Replication over Log Shipping?

Other then cost?
and with cost I don't really understand how it saves money when in log shipping you have a primary and a backup and in Replication you have a publisher and a subscriber

Thanks again