< Back
Stop-DbaService
Post
NAME Stop-DbaService
SYNOPSIS
Stops SQL Server services on a computer.
SYNTAX
Stop-DbaService [[-ComputerName] <Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter[]>] [-InstanceName
<System.String[]>] [-Type <System.String[]>] [-Timeout <Int>] [-Credential <Pscredential>] [-Force <Switch>]
[-EnableException <Switch>] [<CommonParameters>]
Stop-DbaService [-InstanceName <System.String[]>] [-Type <System.String[]>] -InputObject <System.Object[]>
[-Timeout <Int>] [-Credential <Pscredential>] [-Force <Switch>] [-EnableException <Switch>] [<CommonParameters>]
DESCRIPTION
Stops the SQL Server related services on one or more computers. Will follow SQL Server service dependencies.
Requires Local Admin rights on destination computer(s).
PARAMETERS
-ComputerName [<Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter[]>]
The target SQL Server instance or instances.
Required? false
Position? named
Default value
Accept pipeline input? False
Accept wildcard characters? false
-Credential [<Pscredential>]
Credential object used to connect to the computer as a different user.
Required? false
Position? named
Default value
Accept pipeline input? False
Accept wildcard characters? false
-EnableException [<Switch>]
By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.
This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables
advanced scripting.
Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own
try/catch.
Required? false
Position? named
Default value
Accept pipeline input? False
Accept wildcard characters? false
-Force [<Switch>]
Use this switch to stop dependent services before proceeding with the specified service
Required? false
Position? named
Default value
Accept pipeline input? False
Accept wildcard characters? false
-InputObject [<System.Object[]>]
A collection of services from Get-DbaService
Required? false
Position? named
Default value
Accept pipeline input? False
Accept wildcard characters? false
-InstanceName [<System.String[]>]
Only affects services that belong to the specific instances.
Required? false
Position? named
Default value
Accept pipeline input? False
Accept wildcard characters? false
-Timeout [<Int>]
How long to wait for the start/stop request completion before moving on. Specify 0 to wait indefinitely.
Required? false
Position? named
Default value
Accept pipeline input? False
Accept wildcard characters? false
-Type [<System.String[]>]
Use -Type to collect only services of the desired SqlServiceType.
Can be one of the following: "Agent","Browser","Engine","FullText","SSAS","SSIS","SSRS"
Required? false
Position? named
Default value
Accept pipeline input? False
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
NOTES
Tags: Service, Stop
Author: Kirill Kravtsov (@nvarscar)
Website: https://dbatools.io
Copyright: (c) 2018 by dbatools, licensed under MIT
License: MIT https://opensource.org/licenses/MIT
Requires Local Admin rights on destination computer(s).
-------------------------- EXAMPLE 1 --------------------------
PS C:\\>Stop-DbaService -ComputerName sqlserver2014a
Stops the SQL Server related services on computer sqlserver2014a.
-------------------------- EXAMPLE 2 --------------------------
PS C:\\>'sql1','sql2','sql3'| Get-DbaService | Stop-DbaService
Gets the SQL Server related services on computers sql1, sql2 and sql3 and stops them.
-------------------------- EXAMPLE 3 --------------------------
PS C:\\>Stop-DbaService -ComputerName sql1,sql2 -Instance MSSQLSERVER
Stops the SQL Server services related to the default instance MSSQLSERVER on computers sql1 and sql2.
-------------------------- EXAMPLE 4 --------------------------
PS C:\\>Stop-DbaService -ComputerName $MyServers -Type SSRS
Stops the SQL Server related services of type "SSRS" (Reporting Services) on computers in the variable MyServers.
-------------------------- EXAMPLE 5 --------------------------
PS C:\\>Stop-DbaService -ComputerName sql1 -Type Engine -Force
Stops SQL Server database engine services on sql1 forcing dependent SQL Server Agent services to stop as well.
RELATED LINKS
https://dbatools.io/Stop-DbaService
SYNOPSIS
Stops SQL Server services on a computer.
SYNTAX
Stop-DbaService [[-ComputerName] <Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter[]>] [-InstanceName
<System.String[]>] [-Type <System.String[]>] [-Timeout <Int>] [-Credential <Pscredential>] [-Force <Switch>]
[-EnableException <Switch>] [<CommonParameters>]
Stop-DbaService [-InstanceName <System.String[]>] [-Type <System.String[]>] -InputObject <System.Object[]>
[-Timeout <Int>] [-Credential <Pscredential>] [-Force <Switch>] [-EnableException <Switch>] [<CommonParameters>]
DESCRIPTION
Stops the SQL Server related services on one or more computers. Will follow SQL Server service dependencies.
Requires Local Admin rights on destination computer(s).
PARAMETERS
-ComputerName [<Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter[]>]
The target SQL Server instance or instances.
Required? false
Position? named
Default value
Accept pipeline input? False
Accept wildcard characters? false
-Credential [<Pscredential>]
Credential object used to connect to the computer as a different user.
Required? false
Position? named
Default value
Accept pipeline input? False
Accept wildcard characters? false
-EnableException [<Switch>]
By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.
This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables
advanced scripting.
Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own
try/catch.
Required? false
Position? named
Default value
Accept pipeline input? False
Accept wildcard characters? false
-Force [<Switch>]
Use this switch to stop dependent services before proceeding with the specified service
Required? false
Position? named
Default value
Accept pipeline input? False
Accept wildcard characters? false
-InputObject [<System.Object[]>]
A collection of services from Get-DbaService
Required? false
Position? named
Default value
Accept pipeline input? False
Accept wildcard characters? false
-InstanceName [<System.String[]>]
Only affects services that belong to the specific instances.
Required? false
Position? named
Default value
Accept pipeline input? False
Accept wildcard characters? false
-Timeout [<Int>]
How long to wait for the start/stop request completion before moving on. Specify 0 to wait indefinitely.
Required? false
Position? named
Default value
Accept pipeline input? False
Accept wildcard characters? false
-Type [<System.String[]>]
Use -Type to collect only services of the desired SqlServiceType.
Can be one of the following: "Agent","Browser","Engine","FullText","SSAS","SSIS","SSRS"
Required? false
Position? named
Default value
Accept pipeline input? False
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
NOTES
Tags: Service, Stop
Author: Kirill Kravtsov (@nvarscar)
Website: https://dbatools.io
Copyright: (c) 2018 by dbatools, licensed under MIT
License: MIT https://opensource.org/licenses/MIT
Requires Local Admin rights on destination computer(s).
-------------------------- EXAMPLE 1 --------------------------
PS C:\\>Stop-DbaService -ComputerName sqlserver2014a
Stops the SQL Server related services on computer sqlserver2014a.
-------------------------- EXAMPLE 2 --------------------------
PS C:\\>'sql1','sql2','sql3'| Get-DbaService | Stop-DbaService
Gets the SQL Server related services on computers sql1, sql2 and sql3 and stops them.
-------------------------- EXAMPLE 3 --------------------------
PS C:\\>Stop-DbaService -ComputerName sql1,sql2 -Instance MSSQLSERVER
Stops the SQL Server services related to the default instance MSSQLSERVER on computers sql1 and sql2.
-------------------------- EXAMPLE 4 --------------------------
PS C:\\>Stop-DbaService -ComputerName $MyServers -Type SSRS
Stops the SQL Server related services of type "SSRS" (Reporting Services) on computers in the variable MyServers.
-------------------------- EXAMPLE 5 --------------------------
PS C:\\>Stop-DbaService -ComputerName sql1 -Type Engine -Force
Stops SQL Server database engine services on sql1 forcing dependent SQL Server Agent services to stop as well.
RELATED LINKS
https://dbatools.io/Stop-DbaService