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
517 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

948 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

21 Experts available now in Live!

Get 1:1 Help Now