SQL Server Interview: What are the different Startup Options?

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
Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz