Systems Engineering and RDBMS

Start Up Options in SQL Server 2005

Posted by decipherinfosys on January 25, 2009

A reader recently asked how to access the start up options in SQL Server 2005.  In SQL Server 2000, they were able to access it through Enterprise Manager.  In SQL Server 2005, you can do so from the SQL Server Configuration Manager.  As you can see from the image below, you can right click on the service, select properties and then on the Advanced tab, you can get to the startup parameters for that instance – the ones shown in the image below are the default ones:

sql_2k5_startup_1

Besides the default ones, the most commonly used ones are the “-g” or “-T” options.  You can read more about all the   startup options that are available in SQL Server 2005 at this MSDN article here.

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

 
%d bloggers like this: