MSDTC issue in Cluster environment

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » MSDTC issue in Cluster environment

MSDTC issue in Cluster environment

Rate Topic

Display Mode

Topic Options

Author

Message

saidapurs

Posted Thursday, August 23, 2012 3:47 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:46 AM
Points: 167, Visits: 413

Hi All,
I have configured Cluster in my location below are the details of structure.

Q drive 40 GB (Quorum)
S Drive 4 TB (Storage)
M Drive 20 GB (MSDTC)

I tested with Node1 & Node2 (Win Server 2008) both are working fine. Than i installed SQL Cluster on NODE1 and add Node2 in cluster (SQL SERVER 2008) i tested its working very nicely.

ISSUE :- SAN server has been restarted & In my active Node1 showing S & Q drive it not showing M drive. I check with SCSi also not an issue than when i chuck FAIL-OVER CLUSTER ADMINISTRATOR got some errors.

1. Node "1" faild to form a cluster. This was because the witness was
not accessible. Please ensure that the witness resource is online and
available.
Event Id :- 1573

2. Cluster resource "cluster Disk 2" in clustered service or application
'cluster Group' failed.
Event Id :- 1069.

3. Physical drive not detected......
Event Id :- 1034

Let me know the exact issue..

Thanks in advance.

Satish

Post #1348975

AlexSQLForums

Posted Thursday, August 23, 2012 1:50 PM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 11:08 AM
Points: 1,225, Visits: 1,703

if SAN was restarted.
Can you offline-online those disk resources?

Alex S

Post #1349336

saidapurs

Posted Thursday, August 23, 2012 10:27 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:46 AM
Points: 167, Visits: 413

Yes, I did.

After offline & online Quorum & Storage drives came up.

Thanks & Regards
Satish

Post #1349449

Want a cool Sig

Posted Friday, August 24, 2012 9:09 PM

SSC Veteran

Group: General Forum Members
Last Login: Friday, April 26, 2013 2:58 PM
Points: 221, Visits: 452

I've noticed sometimes that on new cluster setups the servers will lose the drive letter or even use a different one when you failover, especially with iSCSI connections. check disk manager and see if you can find it there as an unlabeled disk. Might have to re-assign the drive letter to it again on both nodes. 20GB for MSDTC seems like an awefully large volume.

---------------------------------------------------------------
Mike Hahn - Future MCM 2025 Smile

Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar Hehe

I want a personal webpage Cool

I want to win the lotto BigGrin

I want a gf like Tiffa w00t

Post #1349992

saidapurs

Posted Monday, August 27, 2012 12:34 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:46 AM
Points: 167, Visits: 413

Hi Grass,
Yes you are right, my all drives letters are changed but STORAGE & QUORUM are connected. Let me try to change the letter and reassign the MSDTC drive.

Thanks
Satish

Post #1350217

« Prev Topic | Next Topic »

Permissions