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
544 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
[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
  • 2
5 Comments
 
LVL 40

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 40

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

717 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