Guide me on Windows 2008 and SQL 2008 clustering - Installation

[Preethiviraj Kulasingham]

Hi all,
I am new to Windows and SQL Server clustering.
I want to install Windows 2008 on two servers and have two SQL Server 2008
sp1 clusters. Each instance will be active in its own server but failover to
the other .
I believe in this mechanism, I can use both servers and use high
availability too.
I do not see any issues with the load of the servers. (It is for a test
environment anyway)
Can you guys provide some guidelines or documents on how should I proceed. I
need to know on what type of windows cluster I need to install.

Thansk In Advance.
--

Cheers,
Preethiviraj Kulasingham

[daveberm]

On Jan 23, 3:25 am, Preethiviraj Kulasingham

Preethiviraj,

Basically what you want to do is build a simple active-passive cluster
first, as described here.

http://msdn.microsoft.com/en-us/library/ms189134.aspx
http://msdn.microsoft.com/en-us/library/ms179410.aspx

Once you install SQL into the cluster and on the second node, you will
repeat the process of installing SQL into the cluster, but this time
you will be adding a second instance of SQL on both nodes. The
different SQL cluster instances can then be moved independently
between the cluster nodes, allowing you to run one instance on node A
and one instance on node B while having the other node be available in
case of a failure.

Does that help?

If you are new to clustering, you may want to spend some time in the
online lab to get familiar with some of the concepts.

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?culture=en-US&EventID=1032345932

Let me know if you have any other questions.

Sincerely,

Dave Bermingham