EXPERT RESPONSE
As one of SQL Server 2005's most exciting high availability features, the announcement that Database Mirroring would not be enabled in the RTM version of the product was quite a shock to the user community. Many rumors surfaced, including the assertion that the feature was completely removed from the product.
Database Mirroring was not removed from SQL Server 2005, and as a matter of fact is still in the product as well as the documentation. However, the feature must be explicitly turned on before it can be used, and is supported for development purposes only—use in production environments is only allowed with prior Microsoft approval. The feature was delayed in order to ensure its performance and stability through more extensive testing than was possible during the development cycle. It will be made available for general use during the first half of 2006.
In the meantime, DBAs can enable this feature by using startup trace flag 1400. See SQL Server Books Online for more information.
Do you have comments on this Ask the Expert Q&A? Let us know.
|
