Because the SQL Server Database Engine does not start as a service when starting from the command prompt, use -c to skip this step. Typically, the SQL Server Database Engine starts as a service by calling the Service Control Manager. Shortens startup time when starting SQL Server from the command prompt. If you do not specify this option, the existing registry parameters are used. Is the fully qualified path for the master database log file (typically C:\Program Files\Microsoft SQL Server\MSSQL. If you do not provide this option, the existing registry parameters are used. Is the fully qualified path for the error log file (typically, C:\Program Files\Microsoft SQL Server\MSSQL. Is the fully qualified path for the master database file (typically, C:\Program Files\Microsoft SQL Server\MSSQL. List of Startup Options Default startup options Options For information, see Configure Server Startup Options (SQL Server Configuration Manager). Startup options can be set by using SQL Server Configuration Manager. If the Database Engine cannot locate the necessary files, SQL Server will not start.
![visual studio 2017 sql server database initialization visual studio 2017 sql server database initialization](https://www.brentozar.com/wp-content/uploads/2017/10/10_tempdb-600x427.png)
![visual studio 2017 sql server database initialization visual studio 2017 sql server database initialization](https://i.stack.imgur.com/W7Iw2.png)
You can use these startup options to specify an alternate master database file, master database log file, or error log file.
![visual studio 2017 sql server database initialization visual studio 2017 sql server database initialization](https://crosscuttingconcerns.blob.core.windows.net/images/07401-Visual-Studio-Preview.png)
VISUAL STUDIO 2017 SQL SERVER DATABASE INITIALIZATION INSTALL
When you install SQL Server, Setup writes a set of default startup options in the Microsoft Windows registry. Example: sudo -u mssql /opt/mssql/bin/sqlservr About Startup Options Start SQL Server on Linux with the "mssql" user to prevent future startup issues. Improper use of startup options can affect server performance and can prevent SQL Server from starting.