Windows Server 2003 Cluster

Question

The SAN team has added a new LUN to teh windows cluster. So I can see the disk on both the nodes. I did the intialization, formatting and created a new disk. Now created a new Resource group in the Windows cluster and added the Disk as the resource to the group. Everything seems fine. I have tested the failover and its OK.

now the issue is, as I try to create a new database in SQl server hosted on the cluster, whle choosing the disk drive for the new database files, I dont see the new Drive. I only see the old drives which were added earlier.

What mightbe the cause?

Thanks!

---

Uttam Kumar Sahoo

Answer 1

The drive has to be added as a dependency to SQL Server before it can be seen by the database engine.  This will require taking the SQL Server resource offline to add the drive dependency.

---

Jeff Williams

Answer 2

hi Jeff, Can you please let me know the detailed steps to perform that.. Thanks!

---

Uttam Kumar Sahoo

Answer 3

Sure.

1. Add drive to the SQL Server cluster resource group
2. Take the SQL Server resource offline
3. Modify the SQL Server resource and add the drive as a dependency
4. Bring the SQL Server resource online

 

---

Jeff Williams