Hi!

We are planning to replace our disk system in our SQL Server cluster
environment. Our system consist of two cluster nodes and two SQL Server 2000
instances. There are only SQL Server database files including master
database in this disk system we are replacing.

Can we just shut down sql server resource from cluster administrator and
copy database files to a safety. Then replace the disk system and configure
it so that drive letters are the same as before and configure cluster to see
these drives. Then copy database files back to their old position on this
new disk system and start sql server from cluster administration. What
happens? Does this work or do we have to consider reinstalling sql server?
That would just take too much time...

Thanks

Mikko

Mikko,

Just replacing the drive letters would not be enough to have MSCS recognize
the replaced disk. You should follow the procedure outlined in the following
KB article:

http://support.microsoft.com/?id=305793

Regards,
John

"Mikko Rantonen" <mikko.rantonen (AT) mloy (DOT) fi> wrote

Thanks for your link.

Can we do it so that we first stop sql server cluster resource, then drop
all disks that we are replacing from cluster services and then when new
disks are attached just add those new drives to cluster services?

When everything is in it's place, cluster sees new drives correctly and SQL
server database files are in right places.. will it work?

Thanks

Mikko



"John Toner [MVP]" <jtoner (AT) DIE (DOT) SPAM.DIE.mvps.org> wrote

Hi

Where is the Quorum drive? It has to be on some SAN, this one?
This may affect your planned change even more.

Regards
Mike

"Mikko Rantonen" wrote:

Quorum drive stays as it is! So drives that are been replaced contain only
sql server database files.

Mikko


"Mike Epprecht (SQL MVP)" <mike (AT) epprecht (DOT) net> wrote

I have done this in the past. Replacing the drive letters will work, but
you must recreate the dependancy path in the cluster group as well. Since
there wil be new disk resources with the old letters, you will have to do
this manually.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Mikko Rantonen" <mikko.rantonen (AT) mloy (DOT) fi> wrote