x

Rebuilding SQL Server 2005 cluster

I was trying to get steps to efficiently rebuild a sql server 2005 cluster environment on Windows 2008. Currently on Windows 2003 and sql server 2005. There are stability issues with the current step up. I want to rebuild the environment that has approximately 25 databases. What are the steps involved? What to do or How to move over the databases form the other environment ?

more ▼

asked Dec 08, 2009 at 12:51 PM in Default

Kurt gravatar image

Kurt
1 1 1 1

Are you rebuilding on the same hardware? New hardware? Are you taking downtime?
Dec 08, 2009 at 04:47 PM Steve Jones - Editor ♦♦
(comments are locked)
10|1200 characters needed characters left

2 answers: sort oldest

I find that the easiest way is to setup the new cluster along side the old one, install SQL on the new one. then you get the SAN guys to remove the data, log and other SQL disks you have in the old cluster and attatch them to the new. Then you add sql server depencency to the disks in Failover cluster management and restart teh sql service. Then you can attach all teh databases in the new cluster. You also need to script out your logins, move your SSIS packages and script your jobs. Good luck!

more ▼

answered Jan 11, 2010 at 06:55 AM

Steinar gravatar image

Steinar
1.7k 3 4 6

(comments are locked)
10|1200 characters needed characters left

How many nodes in the cluster? How many SQL instances? Any passive nodes? Do you have spare hardware to rebuild the cluster and once its running well, move the existing databases over?

more ▼

answered Dec 10, 2009 at 06:16 AM

Mark Allison gravatar image

Mark Allison
479 1 1 4

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1951
x102
x93

asked: Dec 08, 2009 at 12:51 PM

Seen: 1670 times

Last Updated: Dec 09, 2009 at 05:10 AM