Friday, March 30, 2012

Replacing disk system in cluster environment.

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@.mloy.fi> wrote in message
news:er7DvFbtEHA.2864@.TK2MSFTNGP09.phx.gbl...
> 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
>
>
|||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@.DIE.SPAM.DIE.mvps.org> wrote in message
news:uzKDWoctEHA.2804@.TK2MSFTNGP14.phx.gbl...
> 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[vbcol=seagreen]
> KB article:
> http://support.microsoft.com/?id=305793
> Regards,
> John
> "Mikko Rantonen" <mikko.rantonen@.mloy.fi> wrote in message
> news:er7DvFbtEHA.2864@.TK2MSFTNGP09.phx.gbl...
> 2000
> configure
> see
this[vbcol=seagreen]
server?
>
|||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:

> 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@.DIE.SPAM.DIE.mvps.org> wrote in message
> news:uzKDWoctEHA.2804@.TK2MSFTNGP14.phx.gbl...
> recognize
> following
> this
> server?
>
>
|||Quorum drive stays as it is! So drives that are been replaced contain only
sql server database files.
Mikko
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:39CB13C4-876F-4DD6-8E81-996DB884D67D@.microsoft.com...[vbcol=seagreen]
> 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:
drop[vbcol=seagreen]
SQL[vbcol=seagreen]
Server[vbcol=seagreen]
and[vbcol=seagreen]
cluster to[vbcol=seagreen]
What[vbcol=seagreen]
|||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@.mloy.fi> wrote in message
news:er7DvFbtEHA.2864@.TK2MSFTNGP09.phx.gbl...
> 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
>
>

No comments:

Post a Comment