[5-day-delivery] Troubleshoot SQL Server Installation

Metadata

• Title: [5-day-delivery] Troubleshoot SQL Server Installation
• Category: 5-day-delivery
• Tag(s): SQL Server, Troubleshoot, Cumulative Update, Installation
• Description: You want to troubleshoot and fix SQL Server Cumulative Update installation issues.

Common Issue(s)

• "Wait on Database Engine recovery handle failed" and errors 912 and 3417 when you run upgrade scripts.
• Setup errors that occur because of missing MSI files or update files in the Windows Installer cache.
• "The Database Engine system data directory in the registry is not valid" or "the User Log directory in the registry is not valid."
• "Network path was not found" and other error messages that you receive if Remote Registry Service or admin shares are disabled on an Always On Failover Cluster instance (FCI) or Always On Availability Groups.

Management

• Fixed-time: 5 working day(s)
• Fixed-scope: 1 server
• Fixed-price: $500

Work Breakdown

• Repair the SQL Server installation
• Use the FixMissingMSI tool
• Use the FindSQLInstalls.vbs script.
• Manually restore the files
• Restore files from system state backups review and implement the procedures that are described in Restore the missing Windows Installer cache files.

Out of Scope

• Root Cause Analysis (RCA)

Deliverable(s)

• The SQL Server Cumulative Update installation should be successful.
• Recommendations
  • Server Level
• Clarification call (up to 1 hour)

Prerequisite(s)

• Database server access
• Screen sharing, if applicable