Error Restoring Backup to SQL Server: "System.Data.SqlClient.SqlError: Logical file 'PMDB_dat' is not part of database 'PMDB'. Use RESTORE FILELISTONLY to list the logical file names."
Last updated on APRIL 18, 2018
Applies to:Primavera P6 Professional Project Management - Version 188.8.131.52 and later
Information in this document applies to any platform.
When attempting to restore a SQL Server database
the following error occurs.
Restore of database 'PMDB' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)
System.Data.SqlClient.SqlError: Logical file 'PMDB_dat' is not part of database 'PMDB'. Use RESTORE FILELISTONLY to list the logical file names. (Microsoft.SqlServer.SmoExtended)
The issue can be reproduced at will with the following steps:
1. Open SQL Server Management Studio and login as SA or authorized Windows Account
2. Right click on Databases, select Restore
3. Run restore, see message that it failed. Click the Failed message and see Error
The issue has the following business impact:
Due to this issue, users cannot restore their database.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms