What should you do?

You are the SQL administrator for your company.
You currently manage a SQL Server 2008 failover cluster thatconsists of six SQL Server 2008 instances named SQL1 , SQL2 , SQL3 , SQL4 , SQL5 , and SQL6.
Because of performance issues, you decide to remove SQL6 from the failover cluster.
What should you do?

You are the SQL administrator for your company.
You currently manage a SQL Server 2008 failover cluster thatconsists of six SQL Server 2008 instances named SQL1 , SQL2 , SQL3 , SQL4 , SQL5 , and SQL6.
Because of performance issues, you decide to remove SQL6 from the failover cluster.
What should you do?

A.
Run the sp_configure system stored procedure on SQL6 .

B.
Run setup.exe from the SQL Server 2008 installation media on SQL6 .

C.
Run the sp_dropserver system stored procedure on SQL6 .

D.
Run the sp_dropdevice system stored procedure on SQL6 .

Explanation:

You should run setup.exe from the SQL Server 2008 installation media on SQL6 . To add or remove SQL Server2008 nodes in a failover cluster, you must use SQL Server setup. You should not run the sp_configure system stored procedure on SQL6 . This system stored procedure is usedto configure server-wide settings, including the fill factor, audit mode, and default language. It cannot be used toremove a server from a failover cluster. You should not run the sp_dropserver system stored procedure on SQL6 . This system stored procedure is usedto remove a remote or linked server from the local SQL Server 2008 instance. Linked servers allow you to usedistributed queries to execute Transact-SQL statements across multiple servers. Although linked servers canexist in a failover cluster, dropping a linked server would not remove a node in a failover cluster. You should not run the sp_dropdevice system stored procedure on SQL6 . This system stored procedure is usedto remove a database device or backup device from a SQL Server 2008 instance. It cannot be used to remove aserver from a failover cluster.

Objective:
Implementing High Availability

Sub-Objective:
Implement a SQL Server clustered instance.

References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Getting Started > Initial Installation > Planning a SQL ServerInstallation > High Availability Solutions Overview > Getting Started with SQL Server 2008 Failover Clustering >Failover Clustering How-to Topics > How To: Add or Remove Nodes in a SQL Server Failover Cluster (Setup)



Leave a Reply 0

Your email address will not be published. Required fields are marked *