Home Library Learn Samples Downloads Support Community Forums
1 out of 3 rated this helpful - Rate this topic

How to: Start an Instance of SQL Server (net Commands)

SQL Server 2005

Updated: 14 April 2006

The Microsoft SQL Server service can be started by using Microsoft Windows net commands.

ms187598.note(en-US,SQL.90).gifNote:
SQL Server running on a cluster is best managed by using Cluster Administrator. For more information, see Using SQL Server Tools with Failover Clustering.

  1. From a command prompt, enter one of the following commands:

    net start "SQL Server (MSSQLSERVER)"

    -or-

    net start MSSQLSERVER

  1. From a command prompt, enter one of the following commands. Replace <instancename> with the name of the instance you want to manage.

    net start "SQL Server ( instancename )"

    -or-

    net start MSSQL$ instancename

  1. Add startup options to the end of the net start "SQL Server (MSSQLSERVER)" statement, separated by a space. When started using net start, startup options use a slash (/) instead of a hyphen (-).

    net start "SQL Server (MSSQLSERVER)" /f /m

    -or-

    net start MSSQLSERVER /f /m

    ms187598.note(en-US,SQL.90).gifNote:
    For more information about startup options, see Using the SQL Server Service Startup Options.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.