Environment:
Windows Server 2003.
2 node Cluster single instance of SQL Server 2K sp3a.
1 SAN.

Cluster groups are:
- Cluster group with its own default resources.
- Oracle group with its own resources.
- SQL Server group with its own resources
(Server,services,disks,ip address....)
Disk v:\ is for SQL Server databases
Disk w:\ is for SQL Server logs
Disk x:\ is for SQL Server backups.

SO now I have to create a shared folder where the clients
need to connect in order to launch the program (executable
file *.exe) and maybe tomorrow I will also need to create
others shared folders where to put others executable.
Questions:
1)Is it correct to create theses shared folders in the SQL
Server group?
2) In wich one of the tree disks?
3) If I have 20 differents programs with differents
security will I end up in having a SQL Server group with
20 different resources (file shares)?
Please advise.
Kind regards.
Franco

If you want all the application resources to failover when SQL Server fails
over, then you can put them on a file share (or multiple file shares, that
depends on your environment/needs) that is a resource in the SQL Server
group. But if the application itself is not cluster aware it will have
problems during failover.

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.