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 FEBRUARY 15, 2023
Applies to:
Primavera P6 Professional Project Management - Version 17.11.0.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to restore a SQL Server database
the following error occurs.
ERROR
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)
STEPS
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
BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot restore their database.
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |