O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required