In SQL Server, if you just want to check which data- and logfiles are included in a database backup device, you can use ‘RESTORE FILELISTONLY FROM xyz’ (with xyz representing the actual device) for this. For example, on my machine, the following command gives the result specified below:
RESTORE FILELISTONLY FROM DISK = 'D:MSSQLBackupMyDB.bak'LogicalName PhysicalName Type FileGroupName Size MaxSize MyDB_Data D:MSSQLDataMyDB_Data.MDF D PRIMARY 6881280 35184372080640 MyDB_Log D:MSSQLDataMyDB_Log.LDF L NULL 2883584 35184372080640