Home > General > SQL Server startup parameters (Part 3)

SQL Server startup parameters (Part 3)

January 28th, 2008 Leave a comment Go to comments

Beginning with SQL Server 2000, Microsoft flagship database product supports multiple instance per server. When starting SQL Server as a service (from Windows Service Manager or from a command line with “net start” notation), instance information is embedded into the SQL Server service definition. When starting SQL Server from the command line in order to start non-default, named instance you need to use -s startup parameter.

-s <instance name> – Starts SQL Server named instance. Sqlservr.exe have to be started from the instance’s Binn directory: (default: C:\Program Files\Microsoft SQL Server\<INSTANCE ID>\MSSQL\ BINN). You can also use -c startup switch alongside -s option to shorten instance startup time.

Categories: General Tags:
  1. No comments yet.
  1. No trackbacks yet.