September 2010
Intermediate to advanced
1704 pages
111h 8m
English
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:

When multiple instances are in use, the service name is something like MSSQL$INSTANCE01. To start such an instance from PowerShell or even the SQL minishell, 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 this as the beginning of a variable when the string is parsed.
The service is stopped. ...