< Back
Restart-DbaService
Post
NAME Restart-DbaService
SYNOPSIS
Restarts SQL Server services on a computer.
SYNTAX
Restart-DbaService [[-ComputerName] <Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter[]>] [-InstanceName
<System.String[]>] [-Type <System.String[]>] [-Timeout <Int>] [-Credential <Pscredential>] [-Force <Switch>]
[-EnableException <Switch>] [<CommonParameters>]
Restart-DbaService [-InstanceName <System.String[]>] [-Type <System.String[]>] -InputObject <System.Object[]>
[-Timeout <Int>] [-Credential <Pscredential>] [-Force <Switch>] [-EnableException <Switch>] [<CommonParameters>]
DESCRIPTION
Restarts 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>]
Will stop dependent SQL Server agents when stopping Engine services.
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, Instance, Restart
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:\\>Restart-DbaService -ComputerName sqlserver2014a
Restarts the SQL Server related services on computer sqlserver2014a.
-------------------------- EXAMPLE 2 --------------------------
PS C:\\>'sql1','sql2','sql3'| Get-DbaService | Restart-DbaService
Gets the SQL Server related services on computers sql1, sql2 and sql3 and restarts them.
-------------------------- EXAMPLE 3 --------------------------
PS C:\\>Restart-DbaService -ComputerName sql1,sql2 -InstanceName MSSQLSERVER
Restarts the SQL Server services related to the default instance MSSQLSERVER on computers sql1 and sql2.
-------------------------- EXAMPLE 4 --------------------------
PS C:\\>Restart-DbaService -ComputerName $MyServers -Type SSRS
Restarts the SQL Server related services of type "SSRS" (Reporting Services) on computers in the variable
MyServers.
-------------------------- EXAMPLE 5 --------------------------
PS C:\\>Restart-DbaService -ComputerName sql1 -Type Engine -Force
Restarts SQL Server database engine services on sql1 forcing dependent SQL Server Agent services to restart as
well.
RELATED LINKS
https://dbatools.io/Restart-DbaService
SYNOPSIS
Restarts SQL Server services on a computer.
SYNTAX
Restart-DbaService [[-ComputerName] <Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter[]>] [-InstanceName
<System.String[]>] [-Type <System.String[]>] [-Timeout <Int>] [-Credential <Pscredential>] [-Force <Switch>]
[-EnableException <Switch>] [<CommonParameters>]
Restart-DbaService [-InstanceName <System.String[]>] [-Type <System.String[]>] -InputObject <System.Object[]>
[-Timeout <Int>] [-Credential <Pscredential>] [-Force <Switch>] [-EnableException <Switch>] [<CommonParameters>]
DESCRIPTION
Restarts 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>]
Will stop dependent SQL Server agents when stopping Engine services.
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, Instance, Restart
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:\\>Restart-DbaService -ComputerName sqlserver2014a
Restarts the SQL Server related services on computer sqlserver2014a.
-------------------------- EXAMPLE 2 --------------------------
PS C:\\>'sql1','sql2','sql3'| Get-DbaService | Restart-DbaService
Gets the SQL Server related services on computers sql1, sql2 and sql3 and restarts them.
-------------------------- EXAMPLE 3 --------------------------
PS C:\\>Restart-DbaService -ComputerName sql1,sql2 -InstanceName MSSQLSERVER
Restarts the SQL Server services related to the default instance MSSQLSERVER on computers sql1 and sql2.
-------------------------- EXAMPLE 4 --------------------------
PS C:\\>Restart-DbaService -ComputerName $MyServers -Type SSRS
Restarts the SQL Server related services of type "SSRS" (Reporting Services) on computers in the variable
MyServers.
-------------------------- EXAMPLE 5 --------------------------
PS C:\\>Restart-DbaService -ComputerName sql1 -Type Engine -Force
Restarts SQL Server database engine services on sql1 forcing dependent SQL Server Agent services to restart as
well.
RELATED LINKS
https://dbatools.io/Restart-DbaService