Groups | Blog | Home
all groups > sql server clustering > march 2005 >

sql server clustering : Shared Folders and SQL Server Cluster


Benjamin Nevarez
3/30/2005 11:31:03 AM

Hello All,

I have a SQL Server 2000/Windows 2003 2-node Cluster single-instance
(active-passive) and it is working perfectly. I also implemented log shipping
from this cluster to a third computer. And also works perfect. But I have
seen that the shared folders in the cluster, required for log shipping,
disappear when I failover from one node to the other.

That is, if node A has the shared folders, and then I failover to node B,
node A no longer has access to the drives holding the shared folders. But if
I failover from node B back to node A, this node has access to the drives
again but the shared folders are gone. And I need to create the shared
folders manually again.

I have seen some possible solutions on Microsoft Knowledge Base articles but
I would like to hear from you if there is a best practice or tested solution
for this issue.

Thanks a lot,

Benjamin Nevarez
SQL Server Database Administrator

Mike Epprecht (SQL MVP)
3/31/2005 5:05:03 AM
Hi

Is your shared folder a resource on the cluster? Don't create it from
Explorer, you have to create it through Cluster Manager.

Regards
Mike

[quoted text, click to view]
Krissi
4/5/2005 12:00:00 AM
Benjamin,

This should help you out:

How to create file shares on a cluster
http://support.microsoft.com/kb/224967


[quoted text, click to view]

AddThis Social Bookmark Button