Denali — Day 8: Startup Parameter

Denali – Day 8: Startup Parameter

Startup Parameters means you are providing the parameter to sql server at the start of sql server, what needs to assign internally, by default you must have to provide following 3 parameters

-d: Specify the location of “Master” database data file.

-l: Specify the location of “Master” database log file.

e: Specify the location of “ErrorLog” file generation location.

These are required parameter by sql server, now apart from this you could also provide different other parameters (optional) depending upon your need and for troubleshooting. At the end of this blog I have provided a link which has all other Startup parameters and its usage.

You can also enable the Trace Flag and can be provided –T parameter for it.

Ok, before Denali, setting the startup parameter was a tuff task where you mistakenly gives wrong Trace or difficult to understand what all parameter has been provide at startup because it was on a single string. Now with Denali setting up startup parameter would be very easy as now “startup parameter” is a separate tab in configuration manager where you can provide it easily


This way you have two push Button’s “Add” and “Removed” where you can add specific parameter and remove it easily, instead of checking it on a string.

http://msdn.microsoft.com/en-us/library/ms190737.aspx

Advertisements
This entry was posted in Denali, Tool, Whats New and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s