Solved

changing a SQL server to clustered box

Posted on 2008-09-30
7
172 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

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

831 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