You can't used a local disk for storing data in a cluster. However, if you
have SQL Server 2005, consider using database mirroring. This will require
a separate instance of SQL Server. Queries are re-directed to the mirror
during your maintenance. Once the maintenance is complete, switch the roles
of primary and mirror.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
[quoted text, click to view]
Hi,

We have a 2 node active \passive windows 2003 cluster hosting SQL and a
virtuals SQL server isntance.

We need to perform maintenance on the SAN (24 hours outage), but need to
still keep SQL accessible. Is there anyway to move data from SAN disk to
local drive of one node and not lose virtual server settings?

There has to be a reasonably painless way to accomplish this...isn't there?