"zycha" <zycha@NOT_FOR_SPAM.COM> wrote in message
news:OnDuY9v8EHA.2196@TK2MSFTNGP11.phx.gbl...
> I am newbie in SQL server and have one, maybe dumb question.
> I have SQL2000 cluster on Windows 2003 with shared storage on SAN.
> Cluster operates with one database only.
> I need to temporary attach second database to SQL server, but problem is
> that I do not have enought free space on shared storage to place both
> databases. It is possible to attach another database in cluster
> environment from local one node drive ? No fail-over needed. Problem is
> that SQL server in cluster see only shared drives. It should look like
> one database in cluster environment and one in not.
> Maybe with two instances or virtual servers ?
> Thanx.

Geoff N. Hiten wrote:
> Short answer is no.
>
> Longer explanation is that in a cluster, all SQL data files must be on a
> cluster disk resource that the SQL server is dependant on. YOu cannot use
> local storage in a SQL 2000 cluster implementation.
>