Technical FAQs

Ask a Question

What are the Default SQL Database Engine Startup Options?

Issue
The default startup options for starting SQL Server service.

Product Line
Microsoft SQL Server (any version)

Environment
SQL Server Configuration Manager

Cause
Startup options designate certain file locations needed during startup.

Resolution
*Warning: Irreparable damage can occur.  This procedure should only be followed by users expert in SQL Server Configuration Manager.*

There are three default startup options:

-d  master_file_path
 Is the fully qualified path for the master database file (typically, C:\Program Files\Microsoft SQL Server\MSSQL11.n\MSSQL\Data\master.mdf).

-e  error_log_path
Is the fully qualified path for the error log file (typically, C:\Program Files\Microsoft SQL Server\MSSQL11.n\MSSQL\LOG\ERRORLOG).

-l  master_log_path
Is the fully qualified path for the master database log file (typically C:\Program Files\Microsoft SQL Server\MSSQL11.n\MSSQL\Data\mastlog.ldf).

NOTES
a.  The '11' refers to SQL Server 2012 and 'n' denotes a named instance (if it exists).
b.  There should be no space between the parameter and the path.

EXAMPLE
-eC:\Program Files\Microsoft SQL Server\MSSQL11.ION\MSSQL\Log\ERRORLOG.


The startup options can be found using SQL Server Configuration Manager:

-  In SQL Server Configuration Manager, click SQL Server Services.
-  In the right pane, right-click SQL Server (<instance_name>), and then click Properties.
-  The Startup Parameters tab has the three parameters.
 
Was this helpful?
What can we do to improve the information ?