question

Kurt avatar image
Kurt asked

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 ?

sql-server-2005restorecluster
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Steve Jones - Editor avatar image Steve Jones - Editor ♦♦ commented ·
Are you rebuilding on the same hardware? New hardware? Are you taking downtime?
1 Like 1 ·
Steinar avatar image
Steinar answered

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!

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mark Allison avatar image
Mark Allison answered

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?

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.