–d – lists the location and file name for the master data file.
–l – lists the location and file name of the master transaction log file.
–e – lists the name and location of the SQL Server error log. One of the most common changes that you
–T – enables you to specify trace flags
–m – starts the SQL Server in a single user mode
–f – Starts SQL Server in a minimal configuration with auditing disabled.
-x – diasbles severals monitoring features
-c – shortens the time needed to start up SQL Server from command line
SQL server start up options
19
Oct