SQL Server Performance Forum – Threads Archive

"Database mirroring should not be used"

Why does Books Online suggest that mirroring should not be used? Other posts here suggest it is live and well and the basis for some clustering solutions. I would like to use to remove single-node dependency in a case where clustering is "too costly". Important:
Microsoft support policies do not apply to the database mirroring feature in SQL Server 2005. Database mirroring is currently disabled by default, but may be enabled for evaluation purposes only by using trace flag 1400 as a startup parameter. (For more information about trace flags, see Trace Flags (Transact-SQL).) Database mirroring should not be used in production environments, and Microsoft support services will not support databases or applications that use database mirroring. Database mirroring documentation is included in SQL Server 2005 for evaluation purposes only, and the Documentation Policy for SQL Server 2005 Support and Upgrade does not apply to the database mirroring documentation.
Source:BOL
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/f1dd6a79-698b-4e31-b923-6bfc3ea0b617.htm

You must be refering to an old version of BOL. Mirroring is fully supported since SP1
Roji. P. Thomas
SQL Server MVP
http://toponewithties.blogspot.com

Today i upgraded my Server with latest Service pack (SP2) and BOL… Still BOL says the same thing… It seems like MS forgot to update BOL… i hope this links will help u http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirfaq.mspx
http://msdn2.microsoft.com/en-us/library/ms189852.aspx Madhu

You have to manually download and update Books Online separately to installing SP2 itself.

Thanks everyone for your help.
Peter

SP2 doesn’t update the books online, as suggested the direct link is to download and update manually.
Don’t know why MS missed on this one to facilitate such utility. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

]]>