SQL Server Restore Filelistonly from disk

Many a times we need to get the details of what is in the database backup device before we do a database restore for e.g. if we have to move the files to new location we need to know the logical database file names contained in the backup device. This is done by SQL Server restore filelistonly command. The query is very simple and is shown below

RESTORE FILELISTONLY FROM DISK='e:\ahmad\Adventureworks2014.bak' WITH FILE=1

The output of the above query is shown below.

sql server restore filelistonly

If a database device contains more than one database backups specify the backup number using FILE=1/2/3/…n. It returns lot more useful information however I have particularly found useful the logicalname and physicalName of the database in the backup device. To get complete details refer to http://msdn.microsoft.com/en-us/library/ms173778.aspx

Happy learning!!!

 

Like us on FaceBook Join the fastest growing SQL Server group on FaceBook

Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Leave a Reply

Your email address will not be published. Required fields are marked *