none
Order for starting and stopping DPM services RRS feed

  • Question

  • Hi,

    we would like to automatically stop and start DPM Services on our DPM 2012R2 Servers with a script.

    It would be nice if anyone could tell me the right order for stopping and starting DPM services .

    Thanks in advance

    regards

    /bkpfast


    My postings are provided "AS IS" with no warranties and confer no rights

    Monday, March 3, 2014 10:58 AM

Answers

  • 1) SQL Server (MSDPM2012)

    2) SQL Server Agent (MSDPM2012)

    3) DPM AccessManager Service

    4) DPM Writer

    5) DPMRA


    Have a nice day !!!

    Monday, March 3, 2014 11:39 AM
    Moderator
  • Stop order

    1) DPM (if started)

    2) DPMRA (if started)

    3) DPM Writer

    4) DPM AccessManager Service

    5) SQL Server Agent (MSDPM2012)

    6) SQL Server (MSDPM2012)


    Have a nice day !!!

    Wednesday, March 5, 2014 7:13 AM
    Moderator

All replies

  • 1) SQL Server (MSDPM2012)

    2) SQL Server Agent (MSDPM2012)

    3) DPM AccessManager Service

    4) DPM Writer

    5) DPMRA


    Have a nice day !!!

    Monday, March 3, 2014 11:39 AM
    Moderator
  • Thanks for your reply!

    I guess that is the start order.
    Startup type of DPMRA is manual...

    Any hints regarding a clean stop order would be nice.

    Thanks in advance...

    /bkpfast


    My postings are provided "AS IS" with no warranties and confer no rights

    Monday, March 3, 2014 1:33 PM
  • Stop order

    1) DPM (if started)

    2) DPMRA (if started)

    3) DPM Writer

    4) DPM AccessManager Service

    5) SQL Server Agent (MSDPM2012)

    6) SQL Server (MSDPM2012)


    Have a nice day !!!

    Wednesday, March 5, 2014 7:13 AM
    Moderator
  • Thank you!

    My postings are provided "AS IS" with no warranties and confer no rights

    Tuesday, March 18, 2014 11:44 AM
  • So, for our DPM 2016, I created following 2 powershell scripts:

    ----Stop-DPM.ps1----

    get-service "ReportServer?DPMSQLSERVER","SQLAgent?DPMSQLSERVER",DPMRA,DPMAMService,"SQLTELEMETRY?DPMSQLSERVER",DpmWriter,MSDPM,"MSSQL?DPMSQLSERVER" | select DisplayName, Status, StartType, CanStop, CanShutdown | ft -a
    # DisplayName                                   Status StartType CanStop CanShutdown
    # -----------                                   ------ --------- ------- -----------
    # DPM AccessManager-Dienst                     Running Automatic    True        True
    # DPMRA                                        Running    Manual    True        True
    # DPM Writer                                   Running Automatic    True        True
    # DPM                                          Running    Manual    True        True
    # SQL Server (DPMSQLSERVER)                    Running Automatic    True        True
    # SQL Server Reporting Services (DPMSQLSERVER) Running Automatic    True        True
    # SQL Server-Agent (DPMSQLSERVER)              Running Automatic    True        True
    # SQL Server CEIP service (DPMSQLSERVER)       Running Automatic    True        True
    
    # Deactivate services so that they can't be restarted by failure-detection mechanisms
    get-service DPMRA,MSDPM | Set-Service -StartupType Disabled
    get-service "ReportServer?DPMSQLSERVER","SQLAgent?DPMSQLSERVER",DPMAMService,"SQLTELEMETRY?DPMSQLSERVER",DpmWriter,"MSSQL?DPMSQLSERVER" | Set-Service -StartupType Disabled
    
    # Stop all services in order
    # Note: get-services seems to be unable to stop some services due to some dependencies?!?
    #       that's why we force stopping of service using net stop commands
    get-service "SQLTELEMETRY?DPMSQLSERVER" | Set-Service -Status Stopped
    get-service "ReportServer?DPMSQLSERVER" | Set-Service -Status Stopped
    #get-service MSDPM | Set-Service -Status Stopped
    net stop msdpm
    #get-service DPMRA | Set-Service -Status Stopped
    net stop DPMRA 
    #get-service DpmWriter | Set-Service -Status Stopped
    net stop DpmWriter 
    get-service DPMAMService | Set-Service -Status Stopped
    #get-service "SQLAgent?DPMSQLSERVER" | Set-Service -Status Stopped
    net stop 'SQLAgent$DPMSQLSERVER'
    #get-service "MSSQL?DPMSQLSERVER" | Set-Service -Status Stopped
    net stop 'MSSQL$DPMSQLSERVER'
    
    

    ----/----

    ----Start-DPM.ps1----

    get-service "ReportServer?DPMSQLSERVER","SQLAgent?DPMSQLSERVER",DPMRA,DPMAMService,"SQLTELEMETRY?DPMSQLSERVER",DpmWriter,MSDPM,"MSSQL?DPMSQLSERVER" | select DisplayName, Status, StartType, CanStop, CanShutdown | ft -a
    # DisplayName                                   Status StartType CanStop CanShutdown
    # -----------                                   ------ --------- ------- -----------
    # DPM AccessManager-Dienst                     Running Automatic    True        True
    # DPMRA                                        Running    Manual    True        True
    # DPM Writer                                   Running Automatic    True        True
    # DPM                                          Running    Manual    True        True
    # SQL Server (DPMSQLSERVER)                    Running Automatic    True        True
    # SQL Server Reporting Services (DPMSQLSERVER) Running Automatic    True        True
    # SQL Server-Agent (DPMSQLSERVER)              Running Automatic    True        True
    # SQL Server CEIP service (DPMSQLSERVER)       Running Automatic    True        True
    
    # Allow services to start again
    get-service DPMRA,MSDPM | Set-Service -StartupType Manual
    get-service "ReportServer?DPMSQLSERVER","SQLAgent?DPMSQLSERVER",DPMAMService,"SQLTELEMETRY?DPMSQLSERVER",DpmWriter,"MSSQL?DPMSQLSERVER" | Set-Service -StartupType Automatic
    
    # Start all services in order
    get-service "MSSQL?DPMSQLSERVER" | Set-Service -Status Running
    get-service "SQLAgent?DPMSQLSERVER" | Set-Service -Status Running
    get-service DPMAMService | Set-Service -Status Running
    get-service DpmWriter | Set-Service -Status Running
    get-service DPMRA | Set-Service -Status Running
    get-service MSDPM | Set-Service -Status Running
    get-service "SQLTELEMETRY?DPMSQLSERVER" | Set-Service -Status Running
    get-service "ReportServer?DPMSQLSERVER" | Set-Service -Status Running
    
    

    ----/----

    Monday, March 6, 2017 2:09 PM