posted Sep 11, 2010, 8:52 PM by Ricardo Fonseca
[
updated Sep 11, 2010, 9:13 PM
]
Following my last post, I summarize here a list of the pros and cons of the different solutions previously discussed. High availability / scalability mode
| Pros
| Cons
| Replication - Transactional - Merge - Snapshot - Peer-to-peer
| [x] Data availability [x] High scalability [x] Can be mixed with db mirroring
[x] Good Reporting Solution [x] Little down time | [x] No automatic fail over [x] Possible Data Loss [x] Latency on secondary server [x] Adv. Setup [x] Adv. Troubleshooting [x] Schema driven
| Log Shipping
| [x] Data availability [x] High scalability [x] Easy Setup (FileSystem) [x] Easy Troubleshooting [x] can be mixed with db mirroring
[x] Good Reporting Solution [x] Little down-time [x] Same database can have multiple destination server | [x] No automatic fail over [x] Latency on secondary server [x] Possible Data Loss
[x] Need Shared Folder setup [x] Require Folder Security | Database Mirroring
| [x] Automatic failover with witness setup [x] High availability [x] Easy Setup [x] Easy Troubleshooting [x] No Data Loss [x] Can be mixed with Log Shipping
| [x] Data availability with latency only over snapshot database
|
|
|