Article ID: 910716 - View products that this article applies to.
This article discusses the requirements for Microsoft SQL Server 2005 and SQL Server 2000 to support remote mirroring of user databases.
Remote mirroring is a solution that is offered by third-party vendors. This solution lets you maintain a real-time mirror of your primary storage device at a remote site. In a remote mirror, redundant server hardware and a redundant storage system are maintained at the remote site. Microsoft SQL Server is installed on both the local server and the remote mirror server.
For more information about remote mirroring, visit the following Microsoft Web site:
http://technet.microsoft.com/en-us/library/cc917708.aspxThe following is a list of requirements for SQL Server to be supported on a remote mirroring solution.
Note This article does not endorse any specific vendor's solution.
Data integrityWork with your hardware vendor and your storage vendor to make sure that the remote mirroring solution that you want to use supports the I/O requirements of SQL Server.
For information about documented vendor solutions, visit the following Microsoft Web site:
http://www.microsoft.com/sql/alwayson.mspxFor information about I/O requirements, visit the following Microsoft TechNet Web site:
http://technet.microsoft.com/en-us/library/cc966500.aspxThe following is a list of some important requirements to consider:
Write-Ahead Logging (WAL) protocolSQL Server deploys a transaction log and an associated recovery logic to make sure that the system maintains transactional database consistency if a system failure or an unmanaged shutdown occurs. This is known as the Write-Ahead Logging (WAL) protocol.
This recovery protocol must be able to write directly through to the disk media. When an operating system I/O write request returns to the database manager, the recovery system must be able to guarantee that the write has actually completed or that the write will be completed. If a hardware or software component of the system does not support this protocol, you may experience partial or total data loss, or the data may become corrupted, if a system failure occurs.
Your solution must meet all requirements for data write ordering and for write-through guarantees. Microsoft will not support any solution that does not meet the WAL requirements. For more information about the WAL requirements, click the following article number to view the article in the Microsoft Knowledge Base:
230785Microsoft Windows-based servers and other storage solutions that are Windows Hardware Quality Lab (WHQL) certified should meet the required guarantees. Therefore, Windows-based servers should be supported for use as SQL Server storage devices. Verify the following with your hardware vendor:
(http://support.microsoft.com/kb/230785/ )SQL Server 7.0, SQL Server 2000, and SQL Server 2005 logging and data storage algorithms extend data reliability
Remote mirroring supportFor more information about remote mirroring and stretch clustering, visit the following Microsoft TechNet Web site:
PerformanceSome remote mirroring solutions may have an adverse effect on overall database performance. This is true especially for solutions that rely on synchronous updates to the remote site. You should carefully consider this point and factor this behavior into the solution that you deploy.
SupportIf your solution meets the requirements that are discussed in this article, Microsoft Customer Support Services will provide support for issues that are not related to storage devices.
Important To obtain support from Microsoft Customer Support Services for issues that involve transactional throughput, you must be able to reproduce the issue in a mirror-free environment.
To obtain support for issues that involve a storage device, see your storage vendor.
To obtain support for issues that involve third-party replication technology, see your technology vendor.
SQL Server requires systems to support ‘ guaranteed delivery to stable media ’ as outlined under the Microsoft SQL Server Always-On Storage Solution Review program. Fo For more information about the input and output requirements for the SQL Server database engine, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/967576/ )Microsoft SQL Server Database Engine Input/Output Requirements
Article ID: 910716 - Last Review: November 20, 2007 - Revision: 2.8