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 1:58 am

    #999737

    GilaMonster (5/25/2009)

    What are the exact startup parameters that you have now?

    I was having the following

    -dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;

    -eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;

    -lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf

    Anyways now I uninstalled and reinstalled SQL server 2005.

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

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

    Thanks.