SQL Server Performance

"Database mirroring should not be used"

Discussion in 'SQL Server 2005 Database Mirroring' started by petersq, Feb 21, 2007.

  1. petersq New Member

    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
  2. Roji. P. Thomas New Member

  3. madhuottapalam New Member

  4. thomas New Member

    You have to manually download and update Books Online separately to installing SP2 itself.
  5. petersq New Member

    Thanks everyone for your help.
    Peter
  6. satya Moderator

    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.

Share This Page