Restore Fails for Database with Consecutive Backslash Characters in File Path

KB ID: 2178
Products: Veeam Backup & Replication
Version: 9.x
Published:
Last Modified: 2016-10-12

Challenge

Veeam Explorer for Microsoft SQL Server reports the error:

Inconsistent database metadata. See log for details.
 

Cause

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

E:\MSSQL\MSSQL12\MSSQL\DATA\\Prod.mdf
E:\MSSQL\MSSQL12\MSSQL\DATA\\Prod_0.ldf

 

Solution

Restore of databases configured in this way is not supported using Veeam Explorer for Microsoft SQL Server. To prevent this problem from occurring in the future, change the file paths of all databases to remove any consecutive backslashes.

As a workaround, the database files can be recovered from the backup via file-level restore. Point-in-time restore is not possible.

 

More Information

A similar issue is described in this Microsoft DPM KB.
 
0 / 5 (0 votes cast)

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!

Orphus system