Can we use one of the shared drives (Data/log/bkp/temp) for configuring MSDTC ?

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  June 7, 2015 at 9:38 pm

  #308902

  Hi Experts,

  We are going to install a SQL Server 2012 Ent. Edition two node (Active/Passive) cluster. Only one instance.

  Issue is, a separate shared storage is not provision for MSDTC.

  1. Is it mandatory to configure MSDTC for a single SQL 2012 instance ?

  2. Can we use one of the shared drives (Data/log/bkp/temp) for configuring MSDTC ?

  Thanks in advance.

  San.

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  June 9, 2015 at 5:34 am

  #1803907

  you should ideally use a separate disk for the DTC resource

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  June 10, 2015 at 4:37 am

  #1804254

  Thanks Perry.

  I understand that its not mandatory from SQL Server 2012 ad it will be using local DTC when its required.

  Hence I am planning NOT to configure MSDTC cluster.

  We are installing only one instance (DB engine and client).

  Do you have any suggestions ?

  Thanks again.