< Back
Start-DbaService
Post
NAME Start-DbaService
SYNOPSIS
Starts SQL Server services on a computer.
SYNTAX
Start-DbaService [[-ComputerName] <Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter[]>] [-InstanceName
<System.String[]>] [-Type <System.String[]>] [-Timeout <Int>] [-Credential <Pscredential>] [-EnableException
<Switch>] [<CommonParameters>]
Start-DbaService [-InstanceName <System.String[]>] [-Type <System.String[]>] -InputObject <System.Object[]>
[-Timeout <Int>] [-Credential <Pscredential>] [-EnableException <Switch>] [<CommonParameters>]
DESCRIPTION
Starts 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
-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, SqlServer, Instance, Connect
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:\\>Start-DbaService -ComputerName sqlserver2014a
Starts the SQL Server related services on computer sqlserver2014a.
-------------------------- EXAMPLE 2 --------------------------
PS C:\\>'sql1','sql2','sql3'| Get-DbaService | Start-DbaService
Gets the SQL Server related services on computers sql1, sql2 and sql3 and starts them.
-------------------------- EXAMPLE 3 --------------------------
PS C:\\>Start-DbaService -ComputerName sql1,sql2 -Instance MSSQLSERVER
Starts the SQL Server services related to the default instance MSSQLSERVER on computers sql1 and sql2.
-------------------------- EXAMPLE 4 --------------------------
PS C:\\>Start-DbaService -ComputerName $MyServers -Type SSRS
Starts the SQL Server related services of type "SSRS" (Reporting Services) on computers in the variable MyServers.
RELATED LINKS
https://dbatools.io/Start-DbaService
SYNOPSIS
Starts SQL Server services on a computer.
SYNTAX
Start-DbaService [[-ComputerName] <Sqlcollaborative.Dbatools.Parameter.DbaInstanceParameter[]>] [-InstanceName
<System.String[]>] [-Type <System.String[]>] [-Timeout <Int>] [-Credential <Pscredential>] [-EnableException
<Switch>] [<CommonParameters>]
Start-DbaService [-InstanceName <System.String[]>] [-Type <System.String[]>] -InputObject <System.Object[]>
[-Timeout <Int>] [-Credential <Pscredential>] [-EnableException <Switch>] [<CommonParameters>]
DESCRIPTION
Starts 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
-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, SqlServer, Instance, Connect
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:\\>Start-DbaService -ComputerName sqlserver2014a
Starts the SQL Server related services on computer sqlserver2014a.
-------------------------- EXAMPLE 2 --------------------------
PS C:\\>'sql1','sql2','sql3'| Get-DbaService | Start-DbaService
Gets the SQL Server related services on computers sql1, sql2 and sql3 and starts them.
-------------------------- EXAMPLE 3 --------------------------
PS C:\\>Start-DbaService -ComputerName sql1,sql2 -Instance MSSQLSERVER
Starts the SQL Server services related to the default instance MSSQLSERVER on computers sql1 and sql2.
-------------------------- EXAMPLE 4 --------------------------
PS C:\\>Start-DbaService -ComputerName $MyServers -Type SSRS
Starts the SQL Server related services of type "SSRS" (Reporting Services) on computers in the variable MyServers.
RELATED LINKS
https://dbatools.io/Start-DbaService