Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Configuration sql 2008 cluster on san storage Expand / Collapse
Author
Message
Posted Monday, February 18, 2013 3:41 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 3:34 AM
Points: 549, Visits: 1,554
Hi All,

Iam unable to proceed with MSDTC storage configration where it fails with the folowing error:


No disk exists in available storage. to add disks click Storage Under actions add a disk

If I do so then I receive a second error stating No disk suitable for cluster disk were found.

We have SAN storage and it is been parttioned to Quorum, msdtc , sql data and sql log folder. and Under stirage I could see only one cluster disk with all these parttion but not able to select and single partition.

Please advice, my configuration is not proceeding further.


"More Green More Oxygen !! Plant a tree today"
Post #1421127
Posted Monday, February 18, 2013 9:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:50 PM
Points: 6,191, Visits: 13,340
what do you see under "Available storage" in the Failover Cluster manager snap in?

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1421267
Posted Monday, February 18, 2013 9:47 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 3:34 AM
Points: 549, Visits: 1,554
Thanks Perry, for taking this up.

When I select Storage from the failover cluster I could see only 1 disk available with 900 GB in size and if I expand that disk I could see all the parttions but not able to map these partitions while configuring MSDTC . Please find the screenshot attached.

Please do let me know what should I do? Earlier I was using starwind for storage but this is the first time we are using SAN.


"More Green More Oxygen !! Plant a tree today"

  Post Attachments 
storage.jpg (15 views, 120.23 KB)
Post #1421422
Posted Tuesday, February 19, 2013 1:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:50 PM
Points: 6,191, Visits: 13,340
Can you supply more info about how the storage is mapped, it seems to be mapped as one large disk group. The group doesn't contain a disk small enough for the MSDTC resource, the smallest is currently 70GB.

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1421472
Posted Tuesday, February 19, 2013 2:44 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:34 AM
Points: 2,859, Visits: 3,187
It looks like you have got all your drives mapped as separate partitions on a single Windows volume.

You need to rebuild this so that each drive letter has its own Windows volume.

Cluster failover works at the Windows volume level, not at the partition level.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1421495
Posted Tuesday, February 26, 2013 10:58 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 3:34 AM
Points: 549, Visits: 1,554
Thanks Perry and EdVassie,

Yes your input to have separate volume have helped me here. I was able to configure the
Active/ Active cluster. So the current structure is 2 node failover active / active cluster

Node X and Node Y.
One windows cluster
2 MSDTC and 2 SQL named instance with failover node X and Y.

One question It only take one single quorum disk. Why is this?

I have 2 public, 2 private and 5 virtual IPS.
2 for MSDTC , 2 Virtual SQL Server NW name and one for windows cluster virtual name.


"More Green More Oxygen !! Plant a tree today"
Post #1424338
Posted Tuesday, February 26, 2013 11:36 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:50 PM
Points: 6,191, Visits: 13,340
The quorum is a single mediator, there is only 1. It can use a file share or disk but also can use neither depending on the cluster configuration.

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1424348
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse