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

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

"Benjamin Nevarez" wrote:

Benjamin,

This should help you out:

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


"Mike Epprecht (SQL MVP)" <mike (AT) epprecht (DOT) net> wrote