Repair a Failed SQL Server Installation

  • Commodity
  • two minutes to read

Applies to: yesSQL Server (all supported versions) - Windows only

Repair operation can be used in the post-obit scenarios:

  • Repair an example of SQL Server that is corrupted after it was successfully installed.

  • Repair an instance of SQL Server if the upgrade operation is cancelled or fails after the instance proper noun is mapped to the newly-upgraded example.

    • If you come across the post-obit message in the summary log, you tin can repair the failed upgrade example:

      "SQL Server upgrade failed. To go on, investigate the reason for the failure, correct the problem, and so repair your installation."

    • If you see the post-obit message in the summary log, you need to uninstall and reinstall SQL Server. Y'all cannot repair the SQL Server instance.

      "SQL Server upgrade failed. To go along, investigate the reason for the failure, right the problem."

When you repair an instance of SQL Server:

  • All missing or corrupt files are replaced.

  • All missing or corrupt registry keys are replaced.

  • All missing or invalid configuration values are set to default values.

Before you continue, for SQL Server failover clusters, review the following of import information:

  • Repair must be run on individual cluster nodes.

  • To repair a failover cluster node after a failed Prepare functioning, use Remove node and then perform the Prepare step again. For more information, see Add or Remove Nodes in a SQL Server Failover Cluster (Setup).

Repair a failed installation of SQL Server from the Installation Centre

  1. Launch the SQL Server Setup program (setup.exe) from SQL Server installation media.

  2. After prerequisites and organisation verification, the Setup program volition brandish the SQL Server Installation Eye page.

  3. Click Maintenance in the left-hand navigation area, and so click Repair to showtime the repair operation.

    Tip

    If the Installation Center was launched using the start carte, you will demand to provide the location of the installation media at this time.

  4. Setup support rule and file routines will run to ensure that your organisation has prerequisites installed and that the computer passes Setup validation rules. Click OK or Install to continue.

  5. On the Select Instance page, select the instance to repair, and then click Next to continue.

  6. The repair rules will run to validate the operation. To keep, click Next.

  7. The Prepare to Repair folio indicates that the operation is set up to keep. To continue, click Repair.

  8. The Repair Progress folio shows the condition of the repair operation. The Complete page indicates that the operation is finished.

To repair a failed installation of SQL Server using Command Prompt

  1. Run the following control at a control prompt:

                      Setup.exe /q /ACTION=Repair /INSTANCENAME=instancename

See Also

View and Read SQL Server Setup Log Files
Installation How-to articles