none
SQL Server Service RRS feed

All replies

  • There are a number of methods. One quick way is to run the command below from a command prompt to list running services and filter for the SQL Server related services:

    net start | findstr "SQL Server"

    If the SQL Server instance is running, you'll see "SQL Server (MSSQLSERVER)" listed. In the case of a named instance, you'll see a different instance name in parenthesis, such as "SQL Server (SQLEXPRESS)" for an express edition named SQLEXPRESS.


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com


    Sunday, September 22, 2019 3:34 PM
    Moderator
  • In addition

    EXEC XP_CMDSHELL 'SQLCMD -L'


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Monday, September 23, 2019 4:19 AM
    Moderator
  • Hi MCC DOOR,

     

    >>How can I be sure that my SQL Server service has started?

    You can find SQL Server(xxx) by entering  ‘services.msc’ in the Run or Command Prompt.

    If the state of the sql server is running, this means that the sql server is running.

    In addition,you can check whether SQL Server Service is started by SQL Server Configuration Manager——SQL Server Services.

    Hope those could help you.

    Best Regards,

    Amelia Gu



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, September 23, 2019 5:23 AM