Microsoft SQL Server Repair Installation

摘要: SQL Server install, SQL repair install, repair install, repair, install, SQL Server corruption, SQL corruption

本文章適用於 本文章不適用於 本文無關於任何特定產品。 本文未識別所有產品版本。
查看其他資源

症狀

Issue: The SQL installation we’re working with has become corrupt preventing the basic functions and features of SQL Server from working as expected.

When the program application binary files of a SQL Server installation become corrupted one of the following options must be followed to ensure a stable working environment for the SQL Server installation.

  1. Perform a new installation of Server and restore SQL Server databases
  2. Move production databases to another like installation of SQL Server
  3. Perform a repair installation of the corrupted SQL Server instance retaining existing Databases  

This article follows the steps involved in performing a SQL Server repair installation.

原因

Software corruption of SQL Server application and database files.

解析度

Installation Process:  

1. Go to the Start Menu of the SQL program group for the instance we are attempting to repair.  Find the "Installation Center" selection on the start menu and open that up.  This example involves SQL Server 2017 and this process is the same for all supported versions of Microsoft SQL Server.
View of SQL Server Installation Center as it is seen on the Microsoft SQL Server Start Menu
2. Next click on the "Maintenance" section in left hand portion of palate.  Find "Repair" in selection list on right side and select.

Location of "repair" option in the Maintenance section of Microsoft SQL Server Installation center
3. In the "Browse For Folder" window find the SQL Server mounted drive as a media source.  The media must match the version of the SQL Server instance we are repairing. Click on the media source to begin the Setup program.
Browse function available to find Microsoft SQL Server installation media for SQL Server repair operation
4. On Servers with multiple installations of SQL Server the Instance requiring repair must be selected from the list of registered SQL Server instances. In example below it is "MSSQLSERVER".
Picking the SQL Server Instance that needs to be repaired
5. The "Ready to Repair" screen will display the program features originally installed.  Select "Repair" button to begin the repair installation.
Selecting the "Repair" option to begin the repair installation
6. "Repair Progress" panel returns installation information.
SQL Server repair operation progress screen
7. Last screen seen reports installation results and should have written a new set of application binaries for the SQL Server instance installation.
Selection screen to define the features that need to be repaired
8. After a successful repair installation, the latest SQL Server cumulative updates should be applied insuring that program binary files will match the versions of SQL Server databases contained under the SQL Server instance.  

受影響的產品

Dell Quickstart Data Warehouse Appliance, Prosupport for Microsoft Software
文章屬性
文章編號: 000128944
文章類型: Solution
上次修改時間: 18 3月 2025
版本:  5
向其他 Dell 使用者尋求您問題的答案
支援服務
檢查您的裝置是否在支援服務的涵蓋範圍內。