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
|
|
|
