Sql 2005 on server 2003 cluster decommissioning


I have been tasked with Decommissioning our old servers cleanly.

I am trying to find a guide on how to cleanly remove a server 2003 cluster running sql 2005.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Deepak ChauhanSQL Server DBACommented:
Have you migrated all SQL and application related stuff to new server, If yes.

Best prectice is first document everything on the server before decommission.

Then take a final backup of all SQL user database and system databases.
Take the disk level bakcup.
Break the Cluster and shut down the node.
You can involve respective team to do this task as per your environment.
Member_2_7494992Author Commented:
thank you for your quick response..

I have moved all databases off the servers.

just wonder if there is any AD cleanups that need to be done other then the removal of the computer accounts.
Deepak ChauhanSQL Server DBACommented:
No very much cleanup require in AD, you are already targetting Computer accounts.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Member_2_7494992Author Commented:
Yes we are cleaning up computer accounts and service accounts.

we are also cleaning up DNS records.
Deepak ChauhanSQL Server DBACommented:
You it is fine.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server OS

From novice to tech pro — start learning today.