Solved

changing a SQL server to clustered box

Posted on 2008-09-30
7
161 Views
Last Modified: 2010-03-19
Currently we are running a SQL server that i would like to upgrade to become a part of a new cluster.
This cluster doesnt exist and i would like to (without reinstalling) make a current SQL 2k5 box a new cluster.

Also the second node that would be added is also running slightly different hardware but will be same OS and ver of SQL 2k5

My basic question is the above feasible (yes im being lazy and cheap) or is this something where the cluster must be built first

cheers
0
Comment
Question by:redmayne
  • 3
  • 2
7 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 22605541
I am pretty sure the cluster has to be built first.
0
 

Author Comment

by:redmayne
ID: 22605605
can you add a current server to a cluster as a node without reinstalling?
(and the hardware thing too i assume thats fine otherwise the software is shite)
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22605653
I don't believe so.  you'll need to add the machine to the cluster then install sql.
0
 

Author Comment

by:redmayne
ID: 22605707
so its a windows cluster then add SQL ?
0
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 22605723
yeah, no such thing as a "sql cluster", its an OS based thing.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

932 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

17 Experts available now in Live!

Get 1:1 Help Now