none
Scrip Needed - DBA RRS feed

  • Question

  • Hi there,

    I need two PS script to stop and start the SQL server related services (Multiple windows Server) for both default and Named instance.

    Engine
    Agent
    Analysis
    Report
    Integration
    browser

    Output should be like as below - 

    Server name Service Name,status,state BEFORE STOP:

    SERVERNAME1 MSSQLSERVER Running Automatic
    SERVERNAME1 MSSQLSERVERAGENT Running Manual
    SERVERNAME2 MSSQLSERVER Running Automatic
    SERVERNAME2 MSSQLSERVERAGENT Running Automatic

    Server name Service Name,status,state AFTER STOP:

    SERVERNAME1 MSSQLSERVER Stoped Automatic
    SERVERNAME1 MSSQLSERVERAGENT Stopped Manual
    SERVERNAME2 MSSQLSERVER Stopped Automatic
    SERVERNAME2 MSSQLSERVERAGENT Stopped Automatic

    Please help me on this, thank you so much in advance for your help. 


    Regards, Dhanapal

    • Moved by Bill_Stewart Friday, March 9, 2018 7:40 PM This is not "scripts on demand"
    Wednesday, November 22, 2017 9:05 AM