SQL Server Performance Forum – Threads Archive

SQL Server Cluster and drives

I have built an active/active cluster with sevral drives, E: data, F: data, L: log, when I installed sql server I specified the data file to be on E: drive. when I try to create a database it only give me the choice of data file and log file to be created on the E: drive. What I want is the ability to create the datafiles on E: and Log file on L:, how can I do that?
another question: I need to failover to the other node when SQL server or SQL server agent fails, how I can do that? Thanx

---

Are the drives part of the SQL Server resource group? All drives with any SQL Server data at all needs to be in the same resource group as the SQL Server services. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

---

Yes they are.

---

I have seen the problem you have described on one of my servers. What I had to do was to manually enter the path I wanted, instead of just browsing for it. This seemed to fix the problem I had. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

---

I have fixed the problem by adding the drives to the dependency of SQL server in the cluster. I still have to try and figure how to failove when sql server agent fails. Thanx Brad for you intrest.

---

Yes you need to add all disks to the dependency list of the SQL Server resource. During install only the Data disk will be added by default. The install does not know if you have additional disks. About SQL Server Agent, as long as the resource is set to "Affect group" under the Properties->Advanced tab, the group will failover if SQL Server Agent fail.

---

I forgot about the dependency issue. Yes, I ran into that issue also, but had forgotten about it. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

---

]]>