Solved

Would you please provide me the checklist to install SQL Server 2008 and SP3 on a Windows Cluster 2008 R2 SP1 Active/Passive node

Posted on 2012-04-11
5
509 Views
Last Modified: 2012-05-16
Hi there,
Would you please provide me the checklist to install SQL Server 2008 and SP3 on a Windows Server 2008 R2 SP1 on Active Passive node? Thank you in advance for your help.
0
Comment
Question by:hpradhan08
  • 3
  • 2
5 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 37834428
Active/Passive should be pretty straight forward running "New SQL Server failover cluster installation" on one node and "Add node to a SQL Server failover cluster" on the other node. Below link is for SQL 2005 but for 2008 would be the same:

http://blogs.msdn.com/b/blakhani/archive/2008/06/09/sql-2005-cluster-setup-checklist.aspx


And this is a walkthrough for "SQL Server 2008 Active-Passive/Active-Active Cluster Installation":
http://sqldbpool.com/2009/10/07/sql-server-2008-active-passive-cluster-installation/
0
 

Author Comment

by:hpradhan08
ID: 37834914
I went throught those docs. But it won't show the process to put the IPs... Don't we need to incoporate the IP SQL CLuster install for the following:


Cluster name (OS cluster) - IP Addresss
Cluster name (SQL cluster) -  IP Addresss
Cluster name(MSDTC) -  IP Addresss
Cluster name(node 1) -  IP Addresss
Cluster name(heartbeat) -  IP Addresss
Cluster name  (node 2) -  IP Addresss
Cluster name (heartbeat) -  IP Addresss

Please provide me the full process to complete the Active/Passive node.
0
 

Author Comment

by:hpradhan08
ID: 37836112
any suggestions please
0
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 37837866
Maybe you should read/follow the steps provided by Microsoft - please search/download: SQLServer2008FailoverCluster.docx
and http://technet.microsoft.com/en-us/library/dd197457


Also very good detals including screen shots "SQL Server 2008 Active-Passive/Active-Active Cluster Installation":
http://sqldbpool.com/2009/10/07/sql-server-2008-active-passive-cluster-installation/


Basicaly the process is done through "Failover Cluster Management tool in Windows Server 2008" which is installed at least on one node and before SQL 2008 install.
0
 

Author Closing Comment

by:hpradhan08
ID: 37978645
good, thanks.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

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.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

706 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now