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