unclustering the sql server 2000 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

unclustering the sql server 2000

Hi all, Is that true that in sql server 2000 all we need to do to break apart the cluster is go through the SQL install wizard (based on below). No evicting the node, etc?
1.
Insert the SQL Server 2000 Enterprise Edition compact disc in your CD-ROM drive. Select Install SQL Server 2000 Components. 2.
Click Install SQL Server 2000 Components, click Install Database Server, and then click Next. 3.
On the Computer Name dialog box, select Virtual Server, and enter the name of an existing clustered instance of SQL Server 2000. 4.
On the Installation Selection dialog box, select Advanced options, and then click Next. 5.
On the Advanced Options dialog box, select Maintain a Virtual Server for Failover Clustering, and then click Next. 6.
On the Failover Clustering dialog box, a TCP/IP address can be added to or removed from the selected instance of SQL Server 2000. To remove a TCP/IP address, select the address, and click Remove. Note: An instance of SQL Server 2000 in a failover cluster requires a TCP/IP address to function. Only remove a TCP/IP address if more than one exists and if this will not affect users or applications accessing SQL Server. To add a TCP/IP address, enter the new TCP/IP address in the IP Address box, select the network to use, and then click Add. The new IP address appears after the existing IP address. 7.
On the Cluster Management dialog box, click Next. 8.
On the Remote Information dialog box, enter the user name and password for the domain administrator account used for the clustered instance of SQL Server 2000, and then click Next. 9.When the process is complete, click Finish.
In SQL 7 there was a whole process with Failover Wizard, etc. Thanks
To remove SQL clustering you just uninstall the SQL 2000 instance(s) through the setup program. After that you can remove windows clustering.
May refer KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;290991&Product=sql2k if you are not totally sure about Argyle’s tip. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
thanks guys

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |