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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Powershell GUI pull downs populated by MS SQL table 2 35
(sql serv16)ssis 2016 question/check 1 64
sql server query 12 24
SQL - Simple Pivot query 8 10
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
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.
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
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

792 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