cluster logical diagram (SQL 2005 2 node cluster - windows 2003

Posted on 2009-04-29
Medium Priority
Last Modified: 2012-05-06
In order to explain to someone the bigger picture of how to configure or setup the SQL 2005 2 node cluster i need to draw a picture on papar that how it will be build. Not the step by step but just a bigger picture.

I will appreciate if someone can give me logical diagram of cluster with virtual servers and nodes in it like which explain what is require to setup sql cluster (2 nodes). Thanks
Question by:tech2010
1 Comment
LVL 12

Accepted Solution

Chris M earned 1500 total points
ID: 24258859
You will setup Windows clustering using Windows 2003 enterprise server OS CDs.
You will have to setup two systems abnd then configure Windows clustering after.
Here's a link you can use: http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/2003_Server/Q_24017020.html

You will need a centralised storage system. I have attached a simple hand drawn diagram to make you understand the setup.
I will explain the difference between a NAS ad a SAN:
A NAS is a Network Attached Storage. This is a storage system that runs on data files. An example is a NetApp machine.
A NAS is just like a SAN (Storage Area Network) in concept but a NAS operates on data files while the SAN operates on disk blocks.
The SAN also allows access to logical volumes via Fibre Channel interconnects while a NAS does so via TCP and also supports Ethernet.
I have attached a sample of the diagram.


Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Screencast - Getting to Know the Pipeline
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

578 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