DP-300 · Question #461
Drag and Drop Question You have an on-premises Microsoft SQL Server failover cluster that contains three nodes. You need to rename a SQL Server instance in the cluster. The solution must minimize…
The correct answer is Rename the SQL Server instance.; Stop the SQL Server instance.; Start the SQL Server instance. To rename a SQL Server instance in a failover cluster while minimizing downtime, you first rename the SQL Server instance (using sp_dropserver and sp_addserver T-SQL commands while the instance is still running), then stop the SQL Server instance to apply the change, and…
Question
Exhibit
Answer Area
Drag items
Correct arrangement
- Rename the SQL Server instance.
- Stop the SQL Server instance.
- Start the SQL Server instance.
Explanation
To rename a SQL Server instance in a failover cluster while minimizing downtime, you first rename the SQL Server instance (using sp_dropserver and sp_addserver T-SQL commands while the instance is still running), then stop the SQL Server instance to apply the change, and finally start the SQL Server instance so it comes back online with the new name. This sequence minimizes downtime because the rename preparation is done while the instance is still running, and only a brief stop/start cycle is required to finalize the change.
Topics
Community Discussion
No community discussion yet for this question.