SQL Server Performance

  • Home
  • Articles
  • Forums
  • Tips
  • Training
  • FAQ's
  • Blogs
  • Software
  • Books
  • About Us
RSS Feeds
Sign in | Join


FAQ Topics

All FAQ's
General DBA
General Developer
DBA Performance Tuning
Developer Performance Tuning
Clustering
Error Messages

USEFUL SITES :

ASP.NET Tutorials
Windows and SQL Azure Tutorials
Cloud Hosting Magazine
SharePoint Tutorials
Windows Server Help

Write for Us

Share your SQL Server knowledge with others and raise your profile in the community More...
Latest Articles

A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server

More     
 
Latest FAQ's

Add Node to A SQL Server failover Cluster failed with invalid ...
SQL Server Destination remote server error
Setting Up Data And Log Files For SQL Server
Will Check Constraints Improve Database Performance?

More     
   
Latest Software Reviews

dbForge Review
Spotlight on ApexSQL Diff - Server-based database comparison tool ...
Spotlight on ApexSQL Data Diff - Server-based database comparison tool ...
Spotlight on ApexSQL Doc 2008

More     

Remove a Node From a SQL Server 2008 Cluster



  1. Run SQL 2008 setup.exe from the node you wish to remove from a cluster (the node to be removed should be the active node), the Installation Wizard will launch the SQL Server Installation Center as shown below

  1. To remove a node from an existing failover cluster instance, click Maintenance in the left-hand pane, and then select Remove node from a SQL Server failover cluster.


  1. When you click remove node it will ask you to run the file

  1. The System Configuration Checker will run a discovery operation on your computer. To continue, click OK, which will create Setup log files for the installation.


  1.  The Installation Wizard will install SQL Server prerequisites if they are not already on the computer which include SQL Server Support Files in this case the prerequisites are already installed, Click Next to continue
  2. On the Cluster Node Configuration page specify the name of the SQL Server 2008 failover cluster instance that will be modified during this Setup operation, the node that will be removed will be listed in the Name of this node field which auto populated. Click next to continue.

  1. The Ready to Remove page displays list of options that will be removed during Setup. To continue, click Remove.

 

  1. During the remove operation, the Remove Node Progress page provides status as shown below

 

  1. On completion remove node page will show the status Complete (success) as shown below, Click Next to continue to go to Complete page which will provide complete summary for the remove node operation
  2. The Complete page provides a link to the summary log file for the remove node operation as shown below, to complete the remove node operation click close

 

  1. Continue this operation from other node which needs to be removed.

 

Ref:

SQL Server 2008 Books Online

 

 

 

 

 








C# Help and Tutorials | PHP MySQL Tutorial | Sharepoint Tutorial | Azure Tutorial | Cloud Hosting Magazine | ASP.NET Tutorials | Windows Server Help | Windows Phone Pro | Silverlight Ace | Visual Studio Tutorials | Home | Peformance Articles | Audit Articles | Business Intelligence Articles | Clustering Articles | Developer Articles | Reporting Services Articles | DBA Articles | ASP.NET / ADO.NET Articles | SQL Server Training Videos | DBA FAQ's | Developer Peformance FAQ's | DBA Peformance FAQ's | Developer FAQ's | Clustering FAQ's | Error Messages | Audit Tool Reviews | Backup Tool Reviews | Coding Tool Reviews | Compare Tool Reviews | Documentation Tool Reviews | Design Tool Reviews | Monitoring Tool Reviews | Log Tool Reviews | Reporting Tool Reviews | Clustering Tool Reviews | Security Tool Reviews | Change Management Tool Reviews | Remote Access Tool Reviews | Book Reviews | Security Tool Reviews | ADO.NET / ASP.NET | Administration | Analysis/OLAP Services | Application Development | Configuration | Components | ETL | Hardware | High Availability | Hints | Index | Misc | Operating Systems | Performance Tuning | Replication | T-SQL | Views


              © 2010 Jude O'Kelly. All rights reserved