Is SQL Server clustering supported/recommended using a
NAS/RAID to hold the database? Here is the hardware setup
Let's say there are 25 computers on a network. Two of
these computers are running as a 2-node SQL server
cluster. The database resides on the Z: drive. The Z:
drive is a NAS. The NAS consists of a server running
Windows 2003 directly attached to a RAID 5 array. The
Windows 2003 node on the NAS front-end is a single point
of failure so we want to add a second Windows 2003 NAS
head and connect it to the RAID-5 array.
Now, these (2) Windows 2003 nodes will implement Windows
2003 clustering using an IP address, computer name, and
the RAID-5 array as the resource. One will be active, the
other be standby. If one Windows 2003 NAS head server
fails the other will take over and the clustered SQL
server will still be able to access the database (Z

.
Are there any problems with this implementation?
Any help would be appreciated.
Regards,
Todd