How do I list the database files contained in a SQL Server 2005 backup file using T-SQL? How do I list the database files contained in a SQL Server 2005 backup file using T-SQL?

For instance:

The restore process will create:

bob.mdf
bob.ldf


etc...
RESTORE FILELISTONLY