Microsoft has published a new Knowledge Base article on the
requirements to receive support for what is known as remote mirroring.
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 |