These are the different options (and the reasons why they weren't suitable for us) :
1. Mirroring - the database mirror can’t be accessed – it's only available if the live database goes down.
2. Log Shipping - the Backup database disconnects users while new transactions being are being applied.
The only viable option was Continuous Replication where data is replicated in realtime every fixed period of time (normally a few minutes).
For our needs Clustering was too expensive. For the record it's for reliability only and offers no performance gains.

No comments:
Post a Comment