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

avatar image

1 1 1 2

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 voted first

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

avatar image

1.7k 4 6 10

(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

avatar image

Mark Allison
479 1 3 8

(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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Dec 08, 2009 at 12:51 PM

Seen: 1876 times

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

Copyright 2018 Redgate Software. Privacy Policy