June 17, 2008 at 10:12 pm
hi,
I installed sql sever 2005 n I need to Add startup trace flags
-T1222
-T3226
So where to set these flags? what is the procedure?
and how to start an instance with /3608 and /f ( here what /f means?)
June 18, 2008 at 1:07 am
Open SQL Configuration Manager, click on SQL Server 2005 Services, then right-click on the SQL Server service and select Properties. Click on the Advanced tab and in the Startup Parameters field, add -T1222 (and/or -T3608) after the other parameters. Parameters should be separated by a semi-colon. The service will then need to be restarted for the trace flag to be enabled.
The -f startup option will start SQL Server in minimal configuration mode. Useful if you've made a configuration change which has stopped SQL Server from working properly.
June 18, 2008 at 2:27 am
OR
DBCC TRACEON (trace_flag_no,-1)
Restart the service to take effect of changes
OR
You can enable trace flag using command prompt.
net stop mssqlserver
net start mssqlserver -Tflag_no
June 18, 2008 at 4:08 am
Using DBCC TRACEON then restarting the SQL Server service will immediately disable the trace flag.
If you only want the trace flag enabled until the SQL Server service is restarted then DBCC TRACEON can be used.
June 18, 2008 at 10:44 am
next -d we need to add traceflags by separating with;?
and the sqlservice should be stooped before adding trace flags?
Correct me if Iam wrong.
June 19, 2008 at 12:23 am
You don't need to change the -d option unless you are moving the master database.
There is no need to stop the SQL Server service before using DBCC TRACEON. If you are enabling the trace flags using Configuration Manager then restart the service after adding the trace flags.
June 19, 2008 at 8:37 am
garyreeds (6/18/2008)
next -d we need to add traceflags by separating with;?and the sqlservice should be stooped before adding trace flags?
Correct me if Iam wrong.
No separators are needed.
e.g -T1204 -T3605
As for stopping the SQL Server service first, this is not necessary. However trace flags added as parameters to the SQL Server service startup will not take affect until the service is restarted.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply