SAN maintenance - still need cluster

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bert69 - 29 Aug 2006 17:41 GMT

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?

Reply to this Message

Tom Moreau - 29 Aug 2006 20:16 GMT

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.

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.

Reply to this Message

Linchi Shea - 29 Aug 2006 21:28 GMT

This is a typical case that can be used to justify a site failover setup. The
site failure setup could be just log shipping, database mirroring, or some
disk-level replication.

Linchi

> Hi,
>
[quoted text clipped - 6 lines]
>
> There has to be a reasonably painless way to accomplish this...isn't there?

Reply to this Message