My Oracle Support Banner

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 APRIL 18, 2018

Applies to:

Primavera P6 Professional Project Management - Version 17.11.0.0 and later
Information 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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.