Windows でのサービスの制御 ref: http://qiita.com/toby_net/items/07bf96d1f56d9dbe6602

file0.txt

PS> gsv | ? { $_.Name -match "sqlserver" }

Status   Name               DisplayName
------   ----               -----------
Running  MSSQLSERVER        SQL Server (MSSQLSERVER)
Running  MSSQLServerOLAP... SQL Server Analysis Services (MSSQL...
Stopped  SQLSERVERAGENT     SQL Server エージェント (MSSQLSERVER)

file1.txt

PS> gsv | ? { $_.Name -match "sql" -and $_.Status -match "Run" }

Status   Name               DisplayName
------   ----               -----------
Running  MSSQLFDLauncher    SQL Full-text Filter Daemon Launche...
Running  MSSQLSERVER        SQL Server (MSSQLSERVER)
Running  MSSQLServerOLAP... SQL Server Analysis Services (MSSQL...
Running  SQLWriter          SQL Server VSS Writer

file2.txt

PS> gsv | ? Name -match "sql" | ? Status -match "Run"

file3.txt

PS> gsv | ? Name -match "mssql" | Stop-Service

file4.txt

PS> gsv | ? Name -match "mssql" | Set-Service -StartupType Manual

file5.txt

PS> gsv | ? Name -match "mssql" | Set-Service -Status Stopped -StartupType Manual
Set-Service : サービス 'SQL Server (MSSQLSERVER) (MSSQLSERVER)' には依存サービスがあるため、停止できません。
発生場所 行:1 文字:31
+ ... Name -match "mssql" | Set-Service -Status Stopped -StartupType Manual
+                           ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (System.ServiceProcess.ServiceController:ServiceController) [Set-Servi
   ce]、ServiceCommandException
    + FullyQualifiedErrorId : ServiceHasDependentServicesNoForce,Microsoft.PowerShell.Commands.SetServiceCommand