Monday, June 29, 2009

Running SQL service as console application

This might be a known fact to many of the SQL users. But I did not knew that SQL service can run as a console application which accepts command line parameters for various level of log tracing. Steps for starting SQL service as console application
1. Stope SQL server service.
2. Start sqlserver.exe in console mode using following command
start /realtime sqlserver.exe -c -s YourInstanceName. Omit -s if you are testing with default instance
3. Pass command line parameter to enable trace flag for e.g. to trace event 3505 pass 'T3505'.
You must switch to the appropriate BINN directory for the instance at a command prompt before starting sqlservr.exe. For example, if Instance1 were to use \mssql$Instance1 for its binaries, the user must be in the \mssql$Instance1\binn directory to start sqlservr.exe -s instance1.
SQL server error log file locationSQL 2008 and 2005-> Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files.

No comments: