https://login.veeam.com/en/oauth?client_id=nXojRrypJ8&redirect_uri=https%3A%2F%2Fwww.veeam.com%2Fservices%2Fauthentication%2Fredirect_url&response_type=code&scope=profile&state=eyJmaW5hbFJlZGlyZWN0TG9jYXRpb24iOiJodHRwczovL3d3dy52ZWVhbS5jb20va2I0MDAyIiwiaGFzaCI6IjU5MzYwYTZmLTA3ZTAtNGM1NC05NDA1LWIwNWY2ZDQxNWQ2ZCJ9
1-800-691-1991 | 9am - 8pm ET
EN

Configuration backup fails with error “Invalid object name 'information_schema.tables'."

Challenge

Configuration backup fails with the following error: Invalid object name 'information_schema.tables'. (System.Data.SqlClient.SqlException). This information can be found in the %Programdata%\Veeam\Backup\Job.Backup_Configuration_Job.Backup.log file.

Cause

The SQL Server instance and database use the Turkish_CI_AS collation. You can check this by using Microsoft SQL Server Management Studio:

  • To check collation for the SQL instance, right-click the SQL instance and click Properties. You will see that the instance has the Turkish_CI_AS collation.
  • To check collation for the SQL database, right-click the Veeam database and click Properties. You will see that the database has the Turkish_CI_AS collation.

Solution

To fix the issue:

  1. Install Microsoft SQL Server Management Studio.
  2. Change the operating system region settings as follows:
    • Format - English (United States);
    • Home location - United States;
    • Current language for non-Unicode programs - English (United States);
    • Copy settings to Welcome screen and system accounts and New user accounts.
  3. Make sure there is no job running in Veeam Backup and Replication and stop all Veeam services.
  4. Create a Microsoft SQL database by using Microsoft SQL Server Management Studio, as described in https://www.veeam.com/kb1471.
  5. Open SQL Server Management Studio and change the following settings for the SQL instance and database:
    • Right-click SQL instance > Properties > Connections. Select the following options:
      • ANSI_NULLS
      • ANSI_WARNINGS
      • ANSI_PADDING
      • QUOTED_IDENTIFIER
      • CONCAT_NULL_YIELDS_NULL
    • Right-click Veeam Database > Properties > Options. Change values of the same options to True:
      • ANSI_NULLS
      • ANSI_WARNINGS
      • ANSI_PADDING
      • QUOTED_IDENTIFIER
      • CONCAT_NULL_YIELDS_NULL
  6. Stop the SQL Server service.
  7. Open PowerShell as Administrator and navigate to cd C:\Program Files\Microsoft SQL Server\<InstanceName>\MSSQL\Binn.
  8. Run the command that changes SQL Server and database collation settings: .\sqlservr.exe -m -T4022 -T3659 -s "<InstanceName>" -Q "Latin_General_CI_AS". The command may take between 2 and 15 mins to complete all necessary changes. When the command completes, you should see: The default collation was successfully changed. Recovery is complete. This is an informational message only. No user action is required. Press [Ctrl+C] and after that [Y].
  9. Start SQL Server and check collation for the SQL instance and database.
  10. If collations are correct, start Veeam services and try to start the configuration backup manually again to create a configuration backup.
KB ID:
4002
Product:
Veeam Backup & Replication 9.5
Published:
2020-08-14
Last Modified:
2020-08-14
Please rate how helpful this article was to you:
5 out of 5 based on 1 ratings
Thank you for helping us improve!
An error occurred during voting. Please try again later.

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

Knowledge base content request
By submitting, you agree that your personal data will be managed by Veeam in accordance with the Privacy Policy.
Your report was sent to the responsible team. Our representative will contact you by email you provided.
We're working on it please try again later