Error: Logical file 'Databasename_Data' is not part of database 'Databasename'. Use RESTORE FILELISTONLY to list the logical file names.
or
Error: Logical file 'Databasename_Log' is not part of database 'Databasename'. Use RESTORE FILELISTONLY to list the logical file names.
Restore script is incorrect or this is a native SQL Server file (not a LiteSpeed generated file)
WORKAROUND:
Use EXEC master.dbo.xp_restore_filelistonly @filename='D:\Backup\\msdb_Full_201107122100.bak' to determine the location of the Logical files. Correct the restore script for the accurate location.
The output will include:
FileNumber, LogicalName, PhysicalName, Type, FileGroupName
Please refer to Sql Server documentation. Or see: http://msdn.microsoft.com/en-us/library/ms173778.aspx
Also, see SOL19167
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy