| Groups | Blog | Home |
sql server clustering : Multi Clusted Named instances.
I have an Win2000 Active/Active Cluster running SQL 2000. Each side of the
cluster is running its own named instance of SQL 2000 Enterprise. Side A has two physical disks F:\ and G:\, Side B has H:\ and I:\. physical disks. The I:\ drive has enough space to house another instance. The cluster has three groups (Cluster Group, SideA, SideB) F:\ and G:\ belong to the SideA Group and H:\ and I:\ drives below to the SideB group. I want to install a second named instance of SQL 2000 that is clustered on Side B and have the files reside on I:\ Is this possible to to have two clustered named instances, it appears to be possible but will i have to add more disks to achieve this? -- * ----------------------------------------- * * Steve Schofield - MCP, CCA * steve@adminblogs.com * * Microsoft MVP - ASP.NET * http://www.adminblogs.com * ----------------------------------------- *
1. If the drive I: is being used by your SideB instance, you should first
make sure that it's not used by the SideB instance. In other words, move the data/log files of the instance to the other drive in the same resource group (e.g. using sp_detach_db/sp_attach_db). 2. Remove the dependency of SideB on the drive I: 3. Add a new resource group called SQLVI3, or whtever name you fancy. 4. Move the drive I: resource to SQLVI3 5. Install your 3rd SQL instance to use the drive I: By the way, I don't think that SideA/SideB is a good naming convention unless you are just making them up and trying to make it easier to communicate. -- Linchi Shea linchi_shea@NOSPAMml.com [quoted text, click to view] "Steve Schofield" <steve@aspfree.com> wrote in message news:e0AHpHDoDHA.2000@TK2MSFTNGP12.phx.gbl... > I have an Win2000 Active/Active Cluster running SQL 2000. Each side of the > cluster is running its own named instance of SQL 2000 Enterprise. Side A > has two physical disks F:\ and G:\, Side B has H:\ and I:\. physical disks. > > The I:\ drive has enough space to house another instance. The cluster has > three groups (Cluster Group, SideA, SideB) F:\ and G:\ belong to the SideA > Group and H:\ and I:\ drives below to the SideB group. I want to install a > second named instance of SQL 2000 that is clustered on Side B and have the > files reside on I:\ Is this possible to to have two clustered named > instances, it appears to be possible but will i have to add more disks to > achieve this? > -- > * ----------------------------------------- * > * Steve Schofield - MCP, CCA > * steve@adminblogs.com > * > * Microsoft MVP - ASP.NET > * http://www.adminblogs.com > * ----------------------------------------- * > >
SideA/SideB just to make it easy to communicate in this email. If I
understand what your saying, two instances can't use the same physical disk clustered resource? SideB would use the H:\ for its named instance and the I:\ would be used for the new 3rd instance. -- * ----------------------------------------- * * Steve Schofield - MCP, CCA * steve@adminblogs.com * * Microsoft MVP - ASP.NET * http://www.adminblogs.com * ----------------------------------------- * [quoted text, click to view] "Linchi Shea" <linchi_shea@NOSPAMml.com> wrote in message news:OQ9kFSDoDHA.1764@tk2msftngp13.phx.gbl... > 1. If the drive I: is being used by your SideB instance, you should first > make sure that it's not used by the SideB instance. In other words, move the > data/log files of the instance to the other drive in the same resource group > (e.g. using sp_detach_db/sp_attach_db). > 2. Remove the dependency of SideB on the drive I: > 3. Add a new resource group called SQLVI3, or whtever name you fancy. > 4. Move the drive I: resource to SQLVI3 > 5. Install your 3rd SQL instance to use the drive I: > > By the way, I don't think that SideA/SideB is a good naming convention > unless you are just making them up and trying to make it easier to > communicate. > > -- > Linchi Shea > linchi_shea@NOSPAMml.com > > > "Steve Schofield" <steve@aspfree.com> wrote in message > news:e0AHpHDoDHA.2000@TK2MSFTNGP12.phx.gbl... > > I have an Win2000 Active/Active Cluster running SQL 2000. Each side of > the > > cluster is running its own named instance of SQL 2000 Enterprise. Side A > > has two physical disks F:\ and G:\, Side B has H:\ and I:\. physical > disks. > > > > The I:\ drive has enough space to house another instance. The cluster > has > > three groups (Cluster Group, SideA, SideB) F:\ and G:\ belong to the > SideA > > Group and H:\ and I:\ drives below to the SideB group. I want to install > a > > second named instance of SQL 2000 that is clustered on Side B and have the > > files reside on I:\ Is this possible to to have two clustered named > > instances, it appears to be possible but will i have to add more disks to > > achieve this? > > -- > > * ----------------------------------------- * > > * Steve Schofield - MCP, CCA > > * steve@adminblogs.com > > * > > * Microsoft MVP - ASP.NET > > * http://www.adminblogs.com > > * ----------------------------------------- * > > > > > >
That's correct. A common disk (aka shared disk) can only be used by a single
SQL virtual server (or a single SQL resource group). Imagine that if two SQL virtual servers could use a common disk at the same time, you then wouldn't be able to failover them independently. -- Linchi Shea linchi_shea@NOSPAMml.com [quoted text, click to view] "Steve Schofield" <steve@aspfree.com> wrote in message news:ObycrWDoDHA.1708@TK2MSFTNGP12.phx.gbl... > SideA/SideB just to make it easy to communicate in this email. If I > understand what your saying, two instances can't use the same physical disk > clustered resource? SideB would use the H:\ for its named instance and the > I:\ would be used for the new 3rd instance. > -- > * ----------------------------------------- * > * Steve Schofield - MCP, CCA > * steve@adminblogs.com > * > * Microsoft MVP - ASP.NET > * http://www.adminblogs.com > * ----------------------------------------- * > "Linchi Shea" <linchi_shea@NOSPAMml.com> wrote in message > news:OQ9kFSDoDHA.1764@tk2msftngp13.phx.gbl... > > 1. If the drive I: is being used by your SideB instance, you should first > > make sure that it's not used by the SideB instance. In other words, move > the > > data/log files of the instance to the other drive in the same resource > group > > (e.g. using sp_detach_db/sp_attach_db). > > 2. Remove the dependency of SideB on the drive I: > > 3. Add a new resource group called SQLVI3, or whtever name you fancy. > > 4. Move the drive I: resource to SQLVI3 > > 5. Install your 3rd SQL instance to use the drive I: > > > > By the way, I don't think that SideA/SideB is a good naming convention > > unless you are just making them up and trying to make it easier to > > communicate. > > > > -- > > Linchi Shea > > linchi_shea@NOSPAMml.com > > > > > > "Steve Schofield" <steve@aspfree.com> wrote in message > > news:e0AHpHDoDHA.2000@TK2MSFTNGP12.phx.gbl... > > > I have an Win2000 Active/Active Cluster running SQL 2000. Each side of > > the > > > cluster is running its own named instance of SQL 2000 Enterprise. Side > A > > > has two physical disks F:\ and G:\, Side B has H:\ and I:\. physical > > disks. > > > > > > The I:\ drive has enough space to house another instance. The cluster > > has > > > three groups (Cluster Group, SideA, SideB) F:\ and G:\ belong to the > > SideA > > > Group and H:\ and I:\ drives below to the SideB group. I want to > install > > a > > > second named instance of SQL 2000 that is clustered on Side B and have > the > > > files reside on I:\ Is this possible to to have two clustered named > > > instances, it appears to be possible but will i have to add more disks > to > > > achieve this? > > > -- > > > * ----------------------------------------- * > > > * Steve Schofield - MCP, CCA > > > * steve@adminblogs.com > > > * > > > * Microsoft MVP - ASP.NET > > > * http://www.adminblogs.com > > > * ----------------------------------------- * > > > > > > > > > > > >
Thanks for the quick reply, these servers are attached to a SAN, it will be
easy to define another disk to create this setup. -- * ----------------------------------------- * * Steve Schofield - MCP, CCA * steve@adminblogs.com * * Microsoft MVP - ASP.NET * http://www.adminblogs.com * ----------------------------------------- * [quoted text, click to view] "Linchi Shea" <linchi_shea@NOSPAMml.com> wrote in message news:Oj2xFDHoDHA.1284@TK2MSFTNGP09.phx.gbl... > That's correct. A common disk (aka shared disk) can only be used by a single > SQL virtual server (or a single SQL resource group). Imagine that if two SQL > virtual servers could use a common disk at the same time, you then wouldn't > be able to failover them independently. > > -- > Linchi Shea > linchi_shea@NOSPAMml.com > > > "Steve Schofield" <steve@aspfree.com> wrote in message > news:ObycrWDoDHA.1708@TK2MSFTNGP12.phx.gbl... > > SideA/SideB just to make it easy to communicate in this email. If I > > understand what your saying, two instances can't use the same physical > disk > > clustered resource? SideB would use the H:\ for its named instance and > the > > I:\ would be used for the new 3rd instance. > > -- > > * ----------------------------------------- * > > * Steve Schofield - MCP, CCA > > * steve@adminblogs.com > > * > > * Microsoft MVP - ASP.NET > > * http://www.adminblogs.com > > * ----------------------------------------- * > > "Linchi Shea" <linchi_shea@NOSPAMml.com> wrote in message > > news:OQ9kFSDoDHA.1764@tk2msftngp13.phx.gbl... > > > 1. If the drive I: is being used by your SideB instance, you should > first > > > make sure that it's not used by the SideB instance. In other words, move > > the > > > data/log files of the instance to the other drive in the same resource > > group > > > (e.g. using sp_detach_db/sp_attach_db). > > > 2. Remove the dependency of SideB on the drive I: > > > 3. Add a new resource group called SQLVI3, or whtever name you fancy. > > > 4. Move the drive I: resource to SQLVI3 > > > 5. Install your 3rd SQL instance to use the drive I: > > > > > > By the way, I don't think that SideA/SideB is a good naming convention > > > unless you are just making them up and trying to make it easier to > > > communicate. > > > > > > -- > > > Linchi Shea > > > linchi_shea@NOSPAMml.com > > > > > > > > > "Steve Schofield" <steve@aspfree.com> wrote in message > > > news:e0AHpHDoDHA.2000@TK2MSFTNGP12.phx.gbl... > > > > I have an Win2000 Active/Active Cluster running SQL 2000. Each side > of > > > the > > > > cluster is running its own named instance of SQL 2000 Enterprise. > Side > > A > > > > has two physical disks F:\ and G:\, Side B has H:\ and I:\. physical > > > disks. > > > > > > > > The I:\ drive has enough space to house another instance. The > cluster > > > has > > > > three groups (Cluster Group, SideA, SideB) F:\ and G:\ belong to the > > > SideA > > > > Group and H:\ and I:\ drives below to the SideB group. I want to > > install > > > a > > > > second named instance of SQL 2000 that is clustered on Side B and have > > the > > > > files reside on I:\ Is this possible to to have two clustered named > > > > instances, it appears to be possible but will i have to add more disks > > to > > > > achieve this? > > > > -- > > > > * ----------------------------------------- * > > > > * Steve Schofield - MCP, CCA > > > > * steve@adminblogs.com > > > > * > > > > * Microsoft MVP - ASP.NET > > > > * http://www.adminblogs.com > > > > * ----------------------------------------- * > > > > > > > > > > > > > > > > > > > >
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 |