1-800-691-1991 | 9am - 8pm ET
EN

Veeam Repair/Reinstall/Upgrade fails with "The following SQL database patches are missed"

KB ID: 4204
Product: Veeam Backup & Replication 11, Veeam Backup & Replication 10
Published: 2021-10-07
Last Modified: 2021-10-07

Challenge

When attempting to repair, reinstall, or upgrade Veeam Backup & Replication the following error occurs:
The following SQL database patches are missed: TFS299663, TFS299403, TFS300354, TFS300785
example of error seen during upgrade
Note: This article is TFS number agnostic and documents how to work around this error.

Cause

The TFS values in the error are related to cumulative updates that have been installed and recorded within the Veeam Backup & Replication configuration database.

The ISO for Cumulative Update releases, indicated by a P in the build number, contain the initial version's installer and the cumulative update patcher. When this ISO is used to install, it first deploys the initial GA build of that version of Veeam Backup & Replication, and then as a post-install action, runs the cumulative update patcher. For example, running the installer for the 11.0.0.837 P20210525 ISO would first install 11.0.0.837, then run the cumulative update patch P20210525.

The cumulative updates may include changes to the configuration database that the base version installer is not compatible with and causes the base version installer to fail when run.

Solution

Error when upgrading from 10a P20210609 to any v11 11.0.0.837 release
The error documented on this KB will occur if attempting to upgrade from Veeam Backup & Replication 10a P20210609 to any release of Veeam Backup & Replication v11 11.0.0.837. As noted on the release page for Veeam Backup & Replication 10a P20210609, that build is only compatible with an upgrade to Veeam Backup & Replication 11a 11.0.1.1261 or higher.
Below are the three known occurrences where this error can be received. Each has its own corrective actions.

Error when repairing Veeam Backup & Replication

This scenario occurs when attempting to use the Veeam Backup & Replication installer's repair function to repair a Veeam Backup & Replication installation that has had cumulative patches applied.

Workaround Steps
This workaround involves changing the database used by the Veeam Backup & Replication software, repairing the Veeam Backup & Replication install, and then switching the software back to using the previous database.
Stop and disable all tasks

Before proceeding ensure that all jobs are stopped and disabled.

If any restore operations are running, stop them.

Part 1: Switch Veeam Backup & Replication to Temporary Database

  1. Open the Veeam.Backup.DBConfig tool.

  2. Select the Veeam Backup & Replication product and click Next.
    (If Backup Enterprise Manager is not installed, this option will not appear.)

  3. On the Connection Settings page, change the Database Name entry to specify the temporary database (e.g., VeeamBackupKB4204Temp)

    Take note of which database was in use, as you will need to enter that in Part 3 of this workaround.

  4. Click Next and answer the prompts as the DBConfig tool stops product services, modifies the database settings, and starts the product services.

  5. On the Summary step of the wizard, only Click Finish. (Do not select the option to "Start the product automatically")
Do not launch Veeam Backup & Replication
Do not launch the application or run Veeam Backup & Replication Console until the entire workaround is completed.

Part 2: Run Veeam Backup & Replication Repair

  1. Mount the Veeam Backup & Replication ISO

  2. Select the option to Install Veeam Backup & Replication

  3. Confirm the License Agreements, click Next

  4. On the Maintenance mode tab of the wizard, select Repair, Click Next

  5. On the following pages, confirm credentials, and finally, click Install to begin the repair.

    (When the repair completes, Proceed to Part 3)

Part 3: Switch Veeam Backup & Replication back to the original database

  1. Open the Veeam.Backup.DBConfig tool.

  2. Select the Veeam Backup & Replication product and click Next.
    (If Backup Enterprise Manager is not installed, this option will not appear.)

  3. On the Connection Settings page, change the Database Name entry to specify the original database.
    (default: VeeamBackup)

  4. Click Next and answer the prompts as the DBConfig tool stops product services, modifies the database settings, and starts the product services.

  5. Click Finish to complete this process.

Error when reinstalling Veeam Backup & Replication

The following steps are intended to be used when all of the following criteria are true:

  • Veeam Backup & Replication has been uninstalled.
  • The version of Veeam Backup & Replication that was installed had a cumulative patch.
  • The intent is to reinstall Veeam Backup & Replication, reusing the previous installs configuration database to retain job/software configuration.
Workaround Steps

This workaround involves installing Veeam Backup & Replication to a temporary database. Then, switching which database the software uses after install to reuse the previous database.

This method will require that you know which SQL instance the existing configuration database is running in and the database name.

 

Part 1: Install Veeam Backup & Replication to a different database.

  1. Mount the Veeam Backup & Replication ISO

  2. Start the install process for Veeam Backup & Replication

  3. Proceed through the steps of the installer. Stop on the SQL Server Instance step.

  4. On the SQL Server Instance Step, enter a temporary database name (e.g., VeeamBackupTempKB4204)

  5. Proceed with the rest of the steps to install Veeam Backup & Replication.

Part 2: Switch Veeam Backup & Replication back to original Database

  1. Open the Veeam.Backup.DBConfig tool.

  2. Select the Veeam Backup & Replication product and click Next.
    (If Backup Enterprise Manager is not installed, this option will not appear.)

  3. On the Connection Settings page, change the Database Name entry to specify the original database
    (default: VeeamBackup)

  4. Click Next and answer the prompts as the DBConfig tool stops product services, modifies the database settings, and starts the product services.

  5. Click Finish to complete this process.

Error when updating Veeam Backup & Replication

When updating between cumulative patches of the same version of Veeam Backup & Replication (e.g., 11.0.0.837 P20210507 to 11.0.0.837 P20210525), use the cumulative update EXE installer, not the ISO.

For the example of updating from 11.0.0.837 P20210507 to 11.0.0.837 P20210525, you would use VeeamBackup&Replication_11.0.0.837_20210525.zip,  not VeeamBackup&Replication_11.0.0.837_20210525.iso.

KB ID: 4204
Product: Veeam Backup & Replication 11, Veeam Backup & Replication 10
Published: 2021-10-07
Last Modified: 2021-10-07

Couldn't find what you were looking for?

Below you can submit an idea for a new knowledge base article.
Report a typo on this page:

Please select a spelling error or a typo on this page with your mouse and press CTRL + Enter to report this mistake to us. Thank you!

Spelling error in text

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Your report was sent to the responsible team. Our representative will contact you by email you provided.

Oops! Something went wrong.

Please try again later.

KB Feedback/Suggestion

By submitting, you are agreeing to have your personal information managed in accordance with the terms of Veeam's Privacy Policy.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Thank you for your interest in Veeam products!
We've sent a verification code to:
  • Incorrect verification code. Please try again.
An email with a verification code was just sent to
Didn't receive the code? Click to resend in sec
Didn't receive the code? Click to resend

ty icon

Thank you!

We have received your request and our team will reach out to you shortly.

OK

error icon

Oops! Something went wrong.

Please try again later.