Now let’s look at some more OS-related tasks, while keeping our focus on SQL Server–related tasks.
Let’s check the status of the SQL Server service using the
Get-Service cmdlet in the regular PowerShell console:
PS>Get-Service "mssqlserver"Status Name DisplayName------ ---- ------------Stopped MSSQLSERVER SQL Server (MSSQLSERVER)PS>
When multiple instances are in use, the service name is something like
MSSQL$INSTANCE01. To start such an instance from PowerShell or even the SQLPS utility, you would have to use the following syntax for the service name:
MSSQL`$INSTANCE01. The dollar sign (
$) character is escaped so that PowerShell doesn’t try to interpret ...