August 7, 2006 at 9:04 pm
Hi all ,
Can anyone assist me with this question .
I am planning to setup trans replication on a sql cluster (sql 2k , windows EE 2003).
Is sharing the snapshot folder using the windows explorer an alternative to configuring the snapshot folder as a cluster shared folder using cluster admin??
I came across the following advice in sqlserver performance site.
"You will have to manually create the required folder on the shared disk resource, and additionally create the necessary share with appropriate permissions. In addition, you will have to configure the shared folder using Cluster administrator as a clustered shared folder."
Can someone tell me the dependencies for the shared folder and the best way to configure it. Create a separate group for shared folder or include it as part of sqlserver group ?? My assumption is that the shared folder is dependent upon disk drive where it resides and the sql network name . I am not sure .
Any assistance is most welcome .
August 7, 2006 at 9:22 pm
A related question to my original post . When the failover happens and the ownership is transferred to the 2nd node (active/passive cluster) , should'nt the sqlserver automatically find the snapshot folder if it resides on a shared disk resource . Why do we have to separately configure he snapshot folder as a shared cluster resource using the cluster admin?? TIA .
August 10, 2006 at 3:27 am
The reason you have to set up the share as a clustered resource is so that it is a part of the virtual server rather than part of one of the individual nodes. If you create the share in Windows Explorer on Node1 then as soon as the disk resource fails over to Node2, the share will fail. When you are configuring replication, you need to specify the snapshot folder in the form \\MyServer\MySnapshotfolder. If MyServer is one of the physical nodes, then the share will only be visible when that node owns the disk resource.
So yes, set up a File Share resource on your cluster. The only dependency it needs is the disk resource upon which the shared folder resides. It follows, therefore, that you create it in the same group as the disk resource.
John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply