I need foolproof instructions for creating a clustered file share on an existing 2-node SQL Server Failover cluster (Windows Server 2003). The scenario is that I have a non-cluster aware application installed on both nodes which needs to create and copy files between subfolders in particular directory. I need a file share that appears to this app as if it's a single folder (e.g. like a network share) regardless of which node in the cluster is active.
I've tried following the instructions in this TechNet article but ran into difficulty straight away. For example, step 1 in the TechNet article says:
- Using Windows Explorer, create a folder on the cluster disk
How do I know which disk is the cluster disk?
In step 4 of the same article, you have to create a physical disk resource. I stopped on page 2 of the wizard when it referred to "possible owners" - should this always be both nodes, and what is the effect of ticking the box "Run this resource in a separate Resource Monitor".
And finally, once I've created the file share, how is this exposed to my application? Do I pass it a UNC path, like a regular file share on a network?
Basically, I need an idiots guide so that I don't mess up the existing SQL configuration.