RSS

SQL server start up options

19 Oct

–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

 
Leave a comment

Posted by on October 19, 2011 in SQL Server

 

Leave a comment