SQL Server Performance

Disaster recovery

Discussion in 'SQL Server 2005 Replication' started by sachinsamuel, Oct 30, 2007.

  1. sachinsamuel New Member

    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
  2. FrankKalis Moderator

  3. thomas New Member

    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.

Share This Page