Basically, you will need to install a local instance on one of the nodes and
then backup the DBs on the clustered instance and restore them onto the
local instance. You'll also have to synch the logins and transfer any
scheduled jobs.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Aaron" <Aaron (AT) Utifix (DOT) uk> wrote

We currently have a 2-node SQL 2005 cluster. We need to break the cluster
and turn it into a standalone server without losing the existing instances
or databases
We want to completely get rid of the clustering, not just run a single-node
sql cluster.
Is this possible?

Thanks.