title: Active - Active DR Strategy for SQL Sever 2005
body: <p>We are trying to come up with an Active - Active DR strategy for our 6 TB data warehouse. Our datawarehouse has 40 DBs and everything has to be replicated on a real time bases.</p>
  
  <p>Site 1 : Needs to handle all the ETL
  Site 2 : Will handle all the reporting queries. </p>
  
  <ul>
  <li>Database Mirroring (Cannot afford to drop and create snapshots as we cannot Kill any connections)</li>
  <li>Replication</li>
  <li>Log shipping</li>
  </ul>
  
  <p>Migrating to SQL Server 2008 is an option.</p>
  
  <p>Which is the best way for performance and availability?</p>
  
  <p>Regards,
  Nagy</p>