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."
(Doc ID 2387531.1)
Last updated on JANUARY 22, 2020
Applies to:Primavera P6 Professional Project Management - Version 18.104.22.168 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document