Re: Help installing SQL2000 on Win2003 - MSDTC resources required?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Great, this is the conclusion that me and my DBA friend came to as
well. I have installed it as described and it now sits in the 'Cluster
Group' with a 4MB MSDTC.log file in a MSdtc folder on the Q drive.

I was just making sure as the webcast is pretty clear that nothing
should be doing I/O to the quorum drive in case the I/O ops prevent
the quorum information being read in a timely manner and causing the
cluster to fail. I guess these days with 10k disks and U320 SCSI
that's not an issue (esp. in light use as I have here).

Thanks!
Ian


On Tue, 06 Sep 2005 14:05:26 GMT, "Nik Marshall-Blank"
<Nik@xxxxxxxxxxxxxxxx> wrote:

>You will need to follow instructions in this link
>
>http://support.microsoft.com/default.aspx?scid=kb;EN-US;817064
>
>This http://support.microsoft.com/?kbid=301600 explains how to create the
>MSDTC resource but you need another physical disk and network name so I
>perform steps 7,8,9, 10,11,12,13 and use the quorum disk and sql server
>network name as these resources and in the same group as the SQL Server
>resource and make the SQLServer resource dependant on the MSDTC resource as
>I had a few times when SQL Server starts before MSDTC and it fails to enlist
>in a transaction.
>
>This works for me.
.

Relevant Pages

  • Re: Help installing SQL2000 on Win2003 - MSDTC resources required?
    ... MSDTC resource but you need another physical disk and network name so I ... network name as these resources and in the same group as the SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • RE: Failed resources
    ... catastrophic result, when I just move one resource to another node, like the ... > Node A hosts normally SQL Server 2K and File System ... > Cluster resource 'Disk Z:' in Resource Group 'Cluster Group' failed. ... > Cluster resource 'Disk V:' in Resource Group 'SQL Server Group' failed. ...
    (microsoft.public.windows.server.clustering)
  • Re: Creating Database (Urgently need help)
    ... Select the SQL Server group. ... Right click in the SLQ SErver resource, ... physical disk NOT in the list cannot be used for SQL data storage. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Disk exchange on two-node MS SQL 2000 active/active cluster
    ... Bring both resource groups to the node you are logged into. ... I support the Professional Association for SQL Server ... >>> physical disk owened by the first node, ... >>> offline with cluster administrator) WHich is better? ...
    (microsoft.public.sqlserver.clustering)
  • Re: MSDTC in Cluster Group
    ... we've found out that it does not work and an instance of SQL Server ... You can put it in the SQL Server Group resource, but it won't work once you ... Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even if the MSDTC has its own IP Address and Network Name? ... In my planned multiple instance sql cluster, I can see giving up a physical disk to the Quarum, but another disk to MSTDC as well. ...
    (microsoft.public.sqlserver.server)