Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning SQL Server stopped after changing startup parameters for mirroring. RE: SQL Server stopped after changing startup parameters for mirroring.

  • May 26, 2009 at 2:13 am

    #999744

    San (5/26/2009)

    Anyways now I uninstalled and reinstalled SQL server 2005.

    I added ;-T1400 in both Principal & mirror server start parameters.

    If both are SP1 or higher, take it out. If not, patch both to SP2 or SP3 and then take it out.

    By the way, why DBCC TRACEON(1400) is used..?

    Because mirroring was unsupported and disabled in RTM and should not be used. After SP1, mirroring was enabled by default and the need for that traceflag fell away

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass