RESTORE FILELISTONLY FROM DISK = 'c:\AdventureWorks2008.bak'
This lists the file locations and sizes of data files inside a backup.
By default, i.e. without specifying WITH MOVE, these are the locations that a RESTORE operation will move data back to.
My real scenario has a fact table partitioned into years and over multiple data files.
MS SQL Tips : What is in your SQL Server backup files?