Home > General, Trace Flags > SQL Server startup parameters (Part 2)

SQL Server startup parameters (Part 2)

January 21st, 2008 Leave a comment Go to comments

There are 3 documented startup parameters that always present in any SQL Server instance. These parameter define location for the SQL Server instance’s master database (data and log files) and also location for the SQL Server instance ERRORLOG file.

-d – SQL Server instance master database data file location (default: C:\Program Files\Microsoft SQL Server\<INSTANCE ID>\MSSQL\Data\ master.mdf).

-l – SQL Server instance master database log file location (default: C:\Program Files\Microsoft SQL Server\<INSTANCE ID>\MSSQL\Data\ mastlog.ldf).

-e – SQL Server instance log file location (default: C:\Program Files\Microsoft SQL Server\<INSTANCE ID>\MSSQL\LOG\ERRORLOG).

These startup flags (and also flags from my previous post) become very useful when you need to move system databases (master, model, temdb for the SQL Server 2000, 2005, 2008 and resource database for the SQL Server 2005 and 2008) to a new location. Complete procedure described in these 2 Microsoft resources:

There are 2 SQL Server trace flags (not documented in the SQL Server Books on-line) that are mentioned in the links provided above and also helpful when you relocate SQL Server instance databases:

trace flag 3608 – bypass instance startup recovery for all database except master (KB 224071)

trace flag 1802 – SQL Server 2005 fix to allow re-attache network share based database files (KB 922804)

Categories: General, Trace Flags Tags:
  1. No comments yet.
  1. No trackbacks yet.