This corresponds to the Microsoft Article 819546.
On a clustered instance of SQL Server 2000, data storage
on mounted drives is not supported.
This applies to Windows 2000 and to Windows
Server 2003.
Mounted drives are sometimes referred to
as "mounted volumes," as "mount points," as "mountpoints,"
or as "volume mount points."
Although mounted drives are a feature of Windows
2000, mounted drives are not supported on Windows 2000
cluster servers because of the failover behavior on
Windows 2000 clustered servers for mounted drives and
because of the assignment of different GUIDs for each disk
on each node. The behavior of mounted volumes on a
failover cluster was fixed for Windows Server 2003.
Windows Server 2003 supports mounted drives in a cluster.
However, because of limitations in SQL Server 2000, the
use of mounted volumes on a clustered instance of SQL
Server 2000 is not supported on any operating system.
A SQL Server 2000 installation is not supported on a
clustered configuration with mounted drives because SQL
Server 2000 was released before the mounted drive feature
was released. The code that is used to enumerate the
shared and the common local fixed disks in SQL Server 2000
in a clustered configuration is not compatible with
mounted drives.
Because of similar limitations, an upgrade of a clustered
instance of SQL Server is not supported. An installation
of SQL Server service packs on a clustered instance of SQL
Server is also not supported.
___________________________________________________________
So, should I take this to mean that we currently can't
upgrade to Server 2003 as it's un-supported for SQL 2000
in a clustered configuration? We currently using SQL
Server 2000 Enterprise Edition with SP3A with Windows 2000
Advanced Server in an Active/Active Cluster.
Please help me with this problem.
