Requirements for SQL Server 2005 and SQL Server 2000 to support remote mirroring of user databases
That's basically where you duplicate a database across sites using a 3rd party vendor solution. Looking over the KB article, it's pretty much the same list we see for geographically dispersed Exchange clusters. However, if you're considering mirroring a database across sites and not using SQL Server 2005's mirroring technology, you'll want to take a look at the article. Microsoft lists the requirements because they are gotchas that can lead to data corruption. For instance, remote mirroring solutions must provide (as per the article):
- Your solution must maintain Dependent Write Consistency.
- Your solution must avoid torn pages.
- Your solution must produce an I/O consistent copy of your data at the secondary remote location.
Technorati Tags: SQL Server | Microsoft SQL Server | SQL Server 2000 | SQL Server 2005