sql dba TRACE FLAGS

TRACE FLAGS:


-d : fully qualified path of datafile
-e : error file
-l : log file
-c: quick start of instance than regular process
-m : sinle user mode
-s : sqlserver.exe
-n : start instance name then the information will not trace in event viewer
-t :refereing startup
==========================================
Trace Flag 3607 :
Starts SQL Server without recovering any databases


Trace Flag 3608 :
Starts SQL Server, recovering master only


User Database Status -32768:
Starts SQL Server without recovering the user database