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