Scrip Needed - DBA

• Question

• 

  

  0

  Sign in to vote

  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