Starting SQL Server with Trace Flags

To start SQL Server with a trace flag, add the -Ttrace_flag_number option to the command line (or in setup), as shown in this example:

sqlservr -dc:\sql\data\master.dat -ec:\sql\log\errorlog     -T4030

Note The -T option is case sensitive. In addition, it does not allow space between the -T and the trace_flag_number.

To start SQL Server with multiple trace flags, repeat the -T option for each trace flag, as shown in this example:

sqlservr -dc:\sql\data\master.dat -ec:\sql\log\errorlog     -T4030 -T4031