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.

No comments:

Post a Comment