"Jeff Swearingen" <jeffvswearingen@gmail.com> wrote in message
news:1170087719.305131.312710@q2g2000cwa.googlegroups.com...
> We have a 2-node single instance SQL 2005 EE SP1 cluster running on
> Windows 2003 EE SP1 and using a SAN.
>
> Suppose a disk drive is configured as a cluster resource for SQL and
> thus SQL has exclusive access to this drive. Does "exclusive" apply
> only to the SQL environment, or does it include other Windows apps?
>
> For example, assuming FTP is also setup on the SQL server, can an
> incoming FTP request read/write files on the same disk drive in the
> cluster resource? The FTP request would be reading files written to
> disk by SQL.
>
> Thanks,
> Jeff
>

> MSCS running on a particular node has exclusive access; however, this means
> exclusive in the sense that no other cluster node has ownership
> (shared-nothing approach).
>
> SQL Server on the other hand only locks the database files exclusively, not
> the volumes on which they reside.
>
> Sincerely,
>
> Anthony Thomas
>
> --
>
> > We have a 2-node single instance SQL 2005 EE SP1 cluster running on
> > Windows 2003 EE SP1 and using a SAN.
>
> > Suppose a disk drive is configured as a cluster resource for SQL and
> > thus SQL has exclusive access to this drive. Does "exclusive" apply
> > only to the SQL environment, or does it include other Windows apps?
>
> > For example, assuming FTP is also setup on the SQL server, can an
> > incoming FTP request read/write files on the same disk drive in the
> > cluster resource? The FTP request would be reading files written to
> > disk by SQL.
>
> > Thanks,
> > Jeff