Disk letter change in SQL 2008 Cluster

Question

I have Sql server 2008 r2 Cluster consists of two nodes and it works fine the only issue I have is when i Failover an instance from one node to the other one the disk letters of the shared storage change and some products like SCOM does not work properly 

Answer 1

Is this using Windows 2003 Cluster?

---

Regards,
Mark Broadbent.

Contact me through (twitter|blog)

---

Please click "Propose As Answer" if a post solves your problem
or "Vote As Helpful" if a post has been useful to you

Answer 2

No using widows server 2008 cluster 

Answer 3

Hi Omar,

Are they Mounted Drives or the Direct Drives..

Example are you using I: for Data J: for Backup..or are you having disks I:\ for Data I:\Backup for Backup?

Answer 4

Hi Hemanth 

they are Direct drives I:\ for Data

 

i get this error in SCOM 

Answer 5

Hi Omar,

Can you please go to Storage section of the cluster and verify if any disks is blocking the drive letter..

And regarding SCOM.. i have configured using the vdb, the best thinng is in SCOM if you configure it as SQL-INFRA\<Driverletter>$ you wont have any issues.

Answer 6

Click run then diskmgmt.msc

Change the disk drive letters or paths as needed to match the other or that of the preffered machine. 

CAution.

Changing this may pop your databases locations.

---

yup