none
SQL Server 2005故障转移群集 RRS feed

  • 问题

  • 各位大神好:

    在windows 2008 R2数据中版的操作系统上安装SQL Server 2005的故障转移群集,需要配置MSDTC吗?

    微软官方文档上有如下一段话:

    在故障转移群集上安装 SQL Server 2005 之前,请确定是否必须创建 Microsoft 分布式事务处理协调器 (MSDTC) 群集资源。如果只安装数据库引擎,则 MSDTC 群集资源不是必需的。如果安装数据库引擎、SSIS、Notification Services 或工作站组件,则必须安装 MSDTC。此要求适用于 Windows 2000 和 Windows Server 2003 操作系统

    链接:http://technet.microsoft.com/zh-cn/library/ms189910(v=sql.90).aspx

    是不是在windows 2008 R2的系统上是不需要配置MSDTC?有些文档上又说,需要配置MSDTC,求真解。谢谢。

    2014年4月27日 9:42

答案

  • 建议配置,如果不配置的话,可能会出现问题,比如

    After you install the operating system and configure your cluster, you must configure MSDTC to work in a cluster by using the Cluster Administrator. Failure to cluster MSDTC will not block SQL Server Setup, but SQL Server application functionality may be affected if MSDTC is not properly configured.
                      Any process running on any node in the cluster can use MSDTC. These processes simply call the MSDTC proxy, and the MSDTC proxy automatically forwards MSDTC calls to the MSDTC transaction manager, which controls the entire cluster.
                      If the node running the MSDTC transaction manager fails, the transaction manager is automatically restarted on another node in the cluster. The newly restarted transaction manager reads the MSDTC log file on the shared cluster disk to determine the outcome of pending and recently completed transactions.


    Please Mark As Answer if it is helpful.

    2014年4月28日 1:18
  • How to Cluster MSDTC:http://msdn.microsoft.com/en-us/library/dd897479(v=bts.10).aspx

    Please Mark As Answer if it is helpful.

    2014年4月28日 3:01

全部回复

  • 建议配置,如果不配置的话,可能会出现问题,比如

    After you install the operating system and configure your cluster, you must configure MSDTC to work in a cluster by using the Cluster Administrator. Failure to cluster MSDTC will not block SQL Server Setup, but SQL Server application functionality may be affected if MSDTC is not properly configured.
                      Any process running on any node in the cluster can use MSDTC. These processes simply call the MSDTC proxy, and the MSDTC proxy automatically forwards MSDTC calls to the MSDTC transaction manager, which controls the entire cluster.
                      If the node running the MSDTC transaction manager fails, the transaction manager is automatically restarted on another node in the cluster. The newly restarted transaction manager reads the MSDTC log file on the shared cluster disk to determine the outcome of pending and recently completed transactions.


    Please Mark As Answer if it is helpful.

    2014年4月28日 1:18
  • 谢谢您的回复。

    有详细的配置文档吗?

    在Windows 2003群集中配置MSDTC,MSDTC没有独立的资源,依赖于群集资源。而在Windows 2008中,MSDTC必须有自己的独立资源?

    2014年4月28日 2:43
  • How to Cluster MSDTC:http://msdn.microsoft.com/en-us/library/dd897479(v=bts.10).aspx

    Please Mark As Answer if it is helpful.

    2014年4月28日 3:01