Restore FileListOnly in SQL Server

Database Backup Restore

I ran a back up of the ABC database, and stored it in D:\Backup\abc.bak.  Now I want to retrieve the files (data file, and log files) name and location path before restoring them in a new location. Which command should I use?

Choose your answer:

RESTORE abc FROM DISK =’D:\Backup\abc.bak’ RESTORE FILELISTONLY FROM DISK=’D:\Backup\abc.bak’ RESTORE VERIFYONLY FROM DISK=’D:\Backup\abc.bak’ None of the Above

Correct answer:	RESTORE FILELISTONLY FROM DISK=’D:\Backup\abc.bak’
Explanation:	RESTORE FILELISTONLY FROM DISK=’D:\Backup\abc.bak’ is the correct answer. The RESTORE FILELISTONLY option allows usto see a list of the files and locations that were backed up. Ref: http://msdn.microsoft.com/en-us/library/ms173778.aspx