Microsoft® SQL Server 2012 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:

Click here to view code image

PS>Get-Service "mssqlserver"Status   Name               DisplayName------   ----               ------------Stopped  MSSQLSERVER   SQL Server (MSSQLSERVER)PS>

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