[AlwaysOn] 创建SQL Server高可用性组T-SQL语法：ENDPOINT_URL子句

ENDPOINT_URL ='TCP://system-address:port'

指定SQL Server实例上数据库镜像终结点的URL路径，该实例承载在当前replica on子句中定义的可用性副本。Specifies the URL path for the database mirroring endpoint on the instance of SQL Server that hosts the availability replica that you are defining in your current REPLICA ON clause.

ENDPOINT_URL 子句是必需的。The ENDPOINT_URL clause is required. 有关详细信息，请参阅在添加或修改可用性副本(SQL Server)时指定端点URL。For more information, see Specify the Endpoint URL When Adding or Modifying an Availability Replica (SQL Server) .

'TCP://system-address:port'

指定用于指定终结点URL或只读路由URL的URL。Specifies a URL for specifying an endpoint URL or read-only routing URL. URL参数如下：The URL parameters are as follows:

system-address

是一个字符串，例如系统名、完全限定的域名或IP地址，它明确标识目标计算机系统。Is a string, such as a system name, a fully qualified domain name, or an IP address, that unambiguously identifies the destination computer system.

port

是与伙伴服务器实例的镜像端点(对于ENDPOINT_URL选项)关联的端口号，或者是服务器实例的数据库引擎使用的端口号(对于READ_ONLY_ROUTING_URL选项)。Is a port number that is associated with the mirroring endpoint of the partner server instance (for the ENDPOINT_URL option) or the port number used by the Database Engine of the server instance (for the READ_ONLY_ROUTING_URL option).

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/81227/viewspace-2653975/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/81227/viewspace-2653975/