SQL 2005 startup parmaeters question
-
Hi, need some confirmation here. I need to change the startup parameters on an important production 2005 instance to add a couple of trace flags, and I won't be here when SQL is bounced. I have nowhere to test this out at the moment (new job) so want to check my syntax and methodology is good. Cannot afford for this to cause problems. :ermm:
Via configuration manager
right click on sql server service, select properties
on advanced tab choose startup parameters
following the -dblah;-eblah;-lblah
append ;-T1222;-T3605
best and correct way to do this?
cheers in advance
george
---------------------------------------------------------------------
-
Yep, that looks good to me. You should be fine.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.ITBookworm.com
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
-
crever,
ta
---------------------------------------------------------------------
-
Order shouldn't matter, never seen it do so in the past, but I've added things to the end so I know what to remove.
Be sure you document your changes.
-
steve, thanks. we have a full blown change management system here (RMS) so all documented and approved.
george
---------------------------------------------------------------------
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply