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.
