Solved

Windows 2000 Adv Server Cluster Vs SQL 2000 Enterprise Server cluster

Posted on 2002-03-13
3
231 Views
Last Modified: 2013-11-15
Hi,
  I need to implement cluster feature for my server, current configuration is as follow
Processor: Dual processor Pentium 1.13Ghz
Memory : 1G
Storage: 70G
Configuration: 2U server.
  Partition C: OS -> 4G
  Partition D: Data -> remaining
  Application is has already been installed
  OS: windows 2000 server
  Database engine: SQL 2000 std edition.

  If I need to have cluster feature. Is this configuration
 go enough? Do I need to have Windows 2000 Advance server & SQL 2000 Enterprise edition for it to work?
   Please advise
   Thanks in advance.
   CT2000
0
Comment
Question by:CT2000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 25

Accepted Solution

by:
dew_associates earned 200 total points
ID: 6863649
Hi CT,

The issue isn't necessarily just whether or not your current hardware configuration is "good enough". There are other issues as well. You don't mention whether you are building a server cluster or implementing the Windows Cluster Service, therefore under the circumstances I will presume you're just implementing the service.

I'd suggest that before you go any further you read the following documentation:

Microsoft Cluster Service Installation Resources

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q259267

You may also want to review these to see which applies to your configuration and setup.

http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=msall&Query=%2522clustering%2520requirements%2522&Queryc=%22clustering+requirements%22&REF=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=25

Be careful of URL wrapping!

Dennis
0
 
LVL 5

Expert Comment

by:matt023
ID: 6866949
There are different ways of clutering - ie: MSCS, parallel processing and load balancing.  the cheapest is to use MS load balancing, however, it's not a good software from my experience.  MS doesn't support parallel processing - Unix related OS's do -- so do Oracle and some other vendors.  MSCS is better, however, the basic harwares that you'll need in order to implement an MSCS solution are:  at leat 2 servers and a shared storage.  there are steps and strict procedures in implementing a cluster solution.  Follow Dennis' advice and get familiar with clustering.
0
 
LVL 4

Expert Comment

by:TheSpirit
ID: 7791186
If you want to use MSCS you would need 2 servers with some kind of shared disk, you would also need to be running Windows 2000 Advanced Server and SQL2000 Enterprise edition. The hardware should also be on the HCL as a solution, it is not enough that each component is on the HCL
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How  to check if a certain node/server backup schedule ran successfully? 4 64
shadow copies 7 86
OLD CPUs 12 106
robocopy 33 146
VM backups can be lost due to a number of reasons: accidental backup deletion, backup file corruption, disk failure, lost or stolen hardware, malicious attack, or due to some other undesired and unpredicted event. Thus, having more than one copy of …
Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question