This post describes how can we get information from backup file without restoring it. information about file groups, data and log files and Database information like server name and user name, internal database version, backup size and etc.
Backup A Database
Backup Database CDB To Disk='D:\CDB_Full.Bak' With MediaName='CDB_FullBackup'
Now we have a backup file located at D:\CDB_full.Bak, With this file following query retrieves information about database Name,UserName, ServerName and Backup Date and etc.
Restore HEADERONLY From Disk='D:\CDB_Full.BAK'
Now let’s get filegroup and file info from backup
Restore FILELISTONLY From Disk='D:\CDB_Full.BAK'
Its really useful when you want to have information about a backup file without restoring it.