Hi Experts, I am planning to create a disaster recovery site for my production database server. But I am not able to identify which option to choose. Not sure if I should go with database mirroring or transactional replication. What are the pros and cons of each option? Production and disaster recovery site location will be geographically very far. Thanks in advance regards S
This is a good place to start: http://www.microsoft.com/sql/technologies/highavailability/default.mspx
Replication is not a HA solution - it's very questionable the microsoft consider it to be one. There is a whole heap of issues with identity columns, non-table objects, referential integrity, fail-back, etc etc. Just don't even consider it. In your case I'd look at Log Shipping. Mirroring is good but needs fast, high-bandwidth links.
