Showing posts with label RESTORE FILELISTONLY in SQLSERVER. Show all posts
Showing posts with label RESTORE FILELISTONLY in SQLSERVER. Show all posts

Wednesday, October 27, 2010

List All files from Backup without restoration, How?

List All files from Backup without restoration:

Here is code for list all files that are in Backup. It just show files list not restore.
Syntax:
RESTORE FILELISTONLY FROM DISK='path of your backup file'

EXAMPLE:
RESTORE FILELISTONLY FROM DISK='D:\mydatabse_backup.bak'

Here 'mydatabse_backup.bak' is my data base backup name. So replace this name with your database backup file name.