Restore Fails for Database with Consecutive Backslash Characters in File Path

KB ID:
2178
Product:
Veeam Backup & Replication
Version:
All
Published:
Last Modified:
2020-05-26

Challenge

Veeam Explorer for Microsoft SQL Server reports the error:

Inconsistent database metadata. See the log for details.

Cause

One or more database file paths contained multiple consecutive backslash characters when the SQL server was backed up.

Solution

Clarifying Issue

This issue cannot be discovered in the GUI of SQL Server Management Studio, because it splits the full file path onto folder path and filename.

To check that the database file paths contain multiple consecutive backslash characters, open SQL Server Management Studio and run the following query against the database reported by Veeam:

SELECT * FROM Sys.Database_files

The query should return a list of database files and their paths (check the "physical_name" column). Below you may see the example of the incorrect path:

D:\Database Files\\DatabaseExample.mdf

In the logs the issue appears with the following trace:

10 (5524) Access to directory granted
10 (5524) Getting file size: C:\VeeamFLR\SQL2008_90f828a2\Volume1\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\\TEST.mdf...
10 (5524) Error: The filename, directory name, or volume label syntax is incorrect

This issue could appear in the following cases:

  • A script used for database creation contains a double backslash in the "Path" variable.
  • The file path for the additional database files was entered with a doubled backslash.

Deploying Hotfix

NOTE: The hotfix is compatible only with Veeam Backup & Replication 10. Customers running earlier versions are advised to upgrade to version 10 first and then install the private fix.

In Veeam Backup & Replication 10, we implemented a mechanism that verifies database paths and automatically replaces a doubled backslash with a single backslash to avoid any issues during a restore.

There is a hotfix required to implement this mechanism for Veeam B&R 10.0.0.4461:

  1. Download the hotfix.
  2. Check the current version of Veeam Backup & Replication. It must be 10.0.0.4461.
  3. Make sure that no jobs are running, close the console, and stop all Veeam services.
  4. Unpack the archive to a TEMP folder
  5. Replace the original files located in the folder below with the hotfix files:
  • C:\Program Files\Veeam\Backup and Replication\Explorers\SQL\
NOTE: MAKE A COPY OF THE ORIGINAL FILES PRIOR TO REPLACING THEM

More Information

[[DOWNLOAD|DOWNLOAD HOTFIX|https://www.veeam.com/download_add_packs/vmware-esx-backup/kb2178]]
MD5 45FEC1F1B3A4C10E0808F02B06457763
SHA-1 B24D071F412AF2C903B3559C799826506F31AD08

Please be aware that we’re making changes which will restrict access to product updates for users without an active contract.

OK

Rate the quality of this KB article: 
3.6 out of 5 based on 4 ratings

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:

Submit