Get-DbaDbServiceBrokerService View Source Ant Green (@ant_green) Windows, Linux, macOS 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. This function helps DBAs audit Service Broker implementations, troubleshoot message-based applications, and document messaging configurations for compliance or migration planning.
Get-DbaService View Source Klaas Vandenberghe (@PowerDbaKlaas) Windows, Linux, macOS 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 View Source Kirill Kravtsov (@nvarscar) Windows, Linux, macOS 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. You can target specific service types (Engine, Agent, SSRS, SSAS, etc.
Start-DbaService View Source Kirill Kravtsov (@nvarscar) Windows, Linux, macOS 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) 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. Commonly used after maintenance windows, server reboots, or when troubleshooting stopped services across an environment.
Stop-DbaService View Source Kirill Kravtsov (@nvarscar) Windows, Linux, macOS 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, and other components across one or more computers. Automatically handles service dependencies to prevent dependency conflicts during shutdown operations.
Particularly useful for planned maintenance windows, troubleshooting service issues, or preparing servers for patching and reboots.
Update-DbaServiceAccount View Source Kirill Kravtsov (@nvarscar) Windows, Linux, macOS 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. Password-only updates don’t require a restart unless you want the changes to take effect immediately.
dbatools