This article is half-done without your Comment! *** Please share your thoughts via Comment ***
If you are preparing for SQL Server DBA interviews, you should prepare yourself with few startup options of SQL Server.
Below, you can find a list of SQL Server startup options:
- -d master_file_path: Change the default location of master database data file
- -l master_log_path: Change the default location of master database log file
- -e error_log_path: Change the default location of SQL Server Error Log file
- -c: Shorten the startup time of SQL Server
- -f: Start SQL Server with minimal configuration
- -m: Start SQL Server in single-user mode
- -E: Increase the number of extents of File groups
- -T trace#: Start an instance of SQL Server with a specified trace flag
- -s: Start a named instance of SQL Server
Leave a Reply