Microsoft® SQL Server 2008 R2 Unleashed

Common OS-Related Tasks

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:

Note

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. ...