Service

Get-DbaDbServiceBrokerService

Ant Green (@ant_green)

Get-DbaDbServiceBrokerService View Source Ant Green (@ant_green) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves Service Broker services from SQL Server databases for auditing and troubleshooting messaging configurations Description Retrieves detailed information about Service Broker services configured in SQL Server databases, including service names, associated queues, schemas, and ownership details. Service Broker services define the endpoints for reliable messaging between applications and databases.

Get-DbaService

Klaas Vandenberghe (@PowerDbaKlaas)

Get-DbaService View Source Klaas Vandenberghe (@PowerDbaKlaas) Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves SQL Server-related Windows services from local or remote computers. Description Retrieves detailed information about SQL Server-related Windows services across one or more computers, including Database Engine, SQL Agent, Reporting Services, Analysis Services, Integration Services, and other SQL Server components. This function replaces manual service management tasks by providing a unified view of service status, startup modes, and service accounts across your SQL Server environment.

Restart-DbaService

Kirill Kravtsov (@nvarscar)

Restart-DbaService View Source Kirill Kravtsov (@nvarscar) Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Restarts SQL Server services with proper dependency handling and service ordering. Description Restarts SQL Server services across multiple computers while automatically managing service dependencies and restart order. This function performs a controlled stop-then-restart sequence, ensuring that dependent services like SQL Agent are properly handled when restarting the Database Engine.

Start-DbaService

Kirill Kravtsov (@nvarscar)

Start-DbaService View Source Kirill Kravtsov (@nvarscar) Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Starts SQL Server related services across multiple computers while respecting service dependencies. Description Starts SQL Server services (Engine, Agent, Browser, FullText, SSAS, SSIS, SSRS, PolyBase, Launchpad) on one or more computers following proper dependency order. This function handles the complexity of starting services in the correct sequence so you don’t have to manually determine which services depend on others.

Stop-DbaService

Kirill Kravtsov (@nvarscar)

Stop-DbaService View Source Kirill Kravtsov (@nvarscar) Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Stops SQL Server-related Windows services with proper dependency handling. Description Stops SQL Server services including Database Engine, SQL Agent, Reporting Services, Analysis Services, Integration Services, PolyBase, Launchpad, and other components across one or more computers. Automatically handles service dependencies to prevent dependency conflicts during shutdown operations.

Update-DbaServiceAccount

Kirill Kravtsov (@nvarscar)

Update-DbaServiceAccount View Source Kirill Kravtsov (@nvarscar) Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Changes the service account or password for SQL Server Engine and Agent services. Description Updates the service account credentials or changes just the password for SQL Server Engine and Agent services. When changing the service account, the affected service will be automatically restarted to apply the changes.