| Groups | Blog | Home |
sql server clustering : Replacing disk system in cluster environment.
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 [quoted text, click to view] "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... > > 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 > > > > > > > > > > > > > > >
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 [quoted text, click to view] "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 > > >
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 [quoted text, click to view] "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 > > >
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 [quoted text, click to view] "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 > 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 > > > > > > > >
Quorum drive stays as it is! So drives that are been replaced contain only sql server database files. Mikko [quoted text, click to view] "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message news:39CB13C4-876F-4DD6-8E81-996DB884D67D@microsoft.com... > 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... > > > 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 > > > > > > > > > > > > > > > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |