Re: Active/Passes Instances on a Single Virtual Server
From: Uttam Parui[MS] (uttamkp_at_online.microsoft.com)
Date: 08/19/04
- Next message: Bob Smith: "RE: Network Path not found to Virtual Cluster - Please Help"
- Previous message: Uttam Parui[MS]: "Re: Network Path not found to Virtual Cluster - Please Help"
- In reply to: Tim G-J: "Re: Active/Passes Instances on a Single Virtual Server"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 19 Aug 2004 15:48:44 GMT
Tim,
I do not properly understand your statement. Can you please elaborate?
You wrote " SQL setup wizard is limiting the installation to select resources on diffrent nodes. If indeed it cannot be done it would be nice to know if this is a limitation of MSCS or SQL Setup."
Please give more detail. What type of resources you are talking about. AFAIK, in the SQL setup wizard the only resource that you select is the the shared disk resources. Yeah, if the disk resource you want to use is
being owned by another node then the setup cannot use it. This is not a limitation, its by design. Meaning Windows cluster uses the "shared nothing" topology where in only one node can own the disk.
You wrote "NB Although there is a BOL entry headed 'How to install a one-node failover cluster' it just install a single instance that doens't failover."
Thats true, you cannot failover because it is a single node cluster. Failover is between nodes and not on the same node.
BTW, if you have more than one shared disk on a single node cluster then you can have multiple virtual SQL Server 2000 (supported upto 16) --- each will require a seperate shared disk.
Additional Information:
====================
I highly recommend you to review the first two links to get an idea of what MSCS and SQL Failover Cluster is, what it can do and what it cannot do.
Windows Clustering: An Overview of Microsoft Clustering Technologies
http://support.microsoft.com/?id=325423
SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx
Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wc051001/wcblurb051001.asp
Microsoft SQL Server 2000 Virtual Server: Things You Should Know
http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wc032602/wcblurb032602.asp
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
- Next message: Bob Smith: "RE: Network Path not found to Virtual Cluster - Please Help"
- Previous message: Uttam Parui[MS]: "Re: Network Path not found to Virtual Cluster - Please Help"
- In reply to: Tim G-J: "Re: Active/Passes Instances on a Single Virtual Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
