Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 SQL 2008 Clustering Question

Author  Topic 

Westside
Starting Member

9 Posts

Posted - 2010-05-24 : 15:12:39
I have two physical Windows 2008 servers (server A & server B), Server "A" has SQL 2008 standard edition on it right now and is our standalone production database server. Server B just has Windows 2008 installed on it.

I want to setup MSCS/SQL Clustering but I'm unclear on the following:

Can I configure Server "B" to be the first node in the cluster, and then add Server "A" as the second node?

-ws

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-24 : 15:27:19
Are the two servers identical? They must be identical to form a stable cluster.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Westside
Starting Member

9 Posts

Posted - 2010-05-24 : 15:31:05
They are almost identical. I understand the goal of having the two servers be identical, but my question is more related to adding a second node to the cluster.

I think I can get the one node up, but I need to add the second node to form the cluster obviously so I'm wondering what the impact will be given that the second node is currently my existing production sql server.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-24 : 15:44:28
Yes you can, however you'll need to run SQL Server setup again: http://technet.microsoft.com/en-us/library/ms191545(SQL.105).aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-24 : 15:46:24
Copy/paste the link as it's not linking properly in this forum. I tried url tags around it, however I couldn't get it to work.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-05-24 : 15:55:47
http://tinyurl.com/24ejfzx
Go to Top of Page

Westside
Starting Member

9 Posts

Posted - 2010-05-24 : 16:30:12
Thanks! Appreciate the help!
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-24 : 16:31:46


Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -