 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Clustering / August 2008Uncluster SQL 2005
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. 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.  SignatureTom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.