Multi-Site High Availability Solution | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Multi-Site High Availability Solution

I want to:
1: insure availability in the event of disaster, So I know I need to have multiple sites. 2: minimze downtime
minimize the maintenance windows for code deployment I think I want to
1: share data between sites
(perhaps some type of partitioning schema and replication)
2: all sites to be active, active – active
I don’t really want to have a duplicate site sitting idle Where do I find an expert in this area? Are the any white paper best practices? Daniel J Pitta
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx By Ron Talmage. Ron’s a great guy. Don’t know the performance implication of doing mirroring at two separate sites, though.
]]>