[Script of Nov. 25] Check the state of all instances in a SQL Server (PowerShell)

  • Article

Script Download: 22123.zip
https://gallery.technet.microsoft.com/scriptcenter/Check-the-state-of-all-1ad2f8d2

This PowerShell script will check the state of all instances in a SQL Server. It will list the name, start mode, state and status of all the instances in a local machine. If there is no instance installed, it will remind you that there is no instance.

Some people asked how to list the state of all instances in a machine. They need get all the instances in their machine and check if they are running or stopped.

image image
image

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery