Copy-DbaEndpoint View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies SQL Server endpoints from source instance to destination instances for migration scenarios.
Description Migrates user-defined endpoints (excluding system endpoints) from a source SQL Server to one or more destination servers. This includes Service Broker, Database Mirroring, and Availability Group endpoints that are essential for high availability configurations.
Existing endpoints on the destination are skipped by default to prevent conflicts, but can be overwritten using the -Force parameter.
Get-DbaEndpoint View Source Garry Bargsley (@gbargsley), blog.garrybargsley.com Windows, Linux, macOS Synopsis Retrieves SQL Server endpoints with network connectivity details for troubleshooting and documentation.
Description Retrieves all SQL Server endpoints including DatabaseMirroring, ServiceBroker, Soap, and TSql types with their network configuration details. This function provides essential information for troubleshooting connectivity issues, documenting high availability setups, and performing security audits. It automatically resolves DNS names and constructs connection strings (FQDN format) for endpoints that have TCP listeners, making it easier to validate network accessibility and plan firewall configurations.
New-DbaEndpoint View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Creates SQL Server endpoints for database mirroring, Service Broker, SOAP, or T-SQL communication.
Description Creates SQL Server endpoints that enable communication between instances for high availability features like availability groups and database mirroring. Database mirroring endpoints are the most common type, required for setting up availability groups and database mirroring partnerships. The function also supports Service Broker endpoints for message queuing, SOAP endpoints for web services, and T-SQL endpoints for remote connections.
Remove-DbaEndpoint View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Removes SQL Server endpoints including DatabaseMirroring, ServiceBroker, Soap, and TSql types.
Description Removes SQL Server endpoints by executing DROP ENDPOINT commands against the target instance. This function handles DatabaseMirroring, ServiceBroker, Soap, and TSql endpoint types, making it useful for decommissioning unused services, cleaning up after failed deployments, or hardening SQL Server instances by removing unnecessary network entry points. You can target specific endpoints by name or remove all endpoints at once, with confirmation prompts to prevent accidental deletions.
Set-DbaEndpoint View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Modifies SQL Server endpoint properties including owner and protocol type.
Description Modifies properties of existing SQL Server endpoints such as changing the owner for security compliance or switching the endpoint type between DatabaseMirroring, ServiceBroker, Soap, and TSql protocols. This is commonly used when transferring endpoint ownership during security audits, changing communication protocols for availability group configurations, or updating Service Broker endpoints for application messaging.
Start-DbaEndpoint View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Starts stopped SQL Server endpoints for Database Mirroring, Service Broker, and other network services.
Description Starts stopped SQL Server endpoints that are required for Database Mirroring, Service Broker, SOAP, and custom TCP connections. Endpoints must be in a started state to accept network connections and facilitate features like Availability Groups, database mirroring partnerships, and Service Broker message routing. This function is commonly used after maintenance windows, server restarts, or when troubleshooting connectivity issues where endpoints were inadvertently stopped.
Stop-DbaEndpoint View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Stops SQL Server communication endpoints like Service Broker, Database Mirroring, or custom TCP endpoints.
Description Stops specific or all SQL Server endpoints on target instances. Endpoints are communication channels that SQL Server uses for features like Service Broker messaging, Database Mirroring, Availability Groups, and custom applications. You might need to stop endpoints during maintenance windows, troubleshooting connectivity issues, or when decommissioning specific services.
Test-DbaEndpoint View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Tests network connectivity to SQL Server endpoint TCP listener ports.
Description Tests network connectivity to SQL Server endpoint TCP listener ports by attempting direct socket connections. This function validates that endpoint ports are accessible from the network level, which is essential for troubleshooting database mirroring, Service Broker, and availability group connectivity issues.
The function tests both standard TCP ports and SSL ports when configured, returning connection status rather than endpoint functionality.
dbatools