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
从其他戴尔用户那里查找问题的答案
支持服务
检查您的设备是否在支持服务涵盖的范围内。