List header data from Backup without restoration:
Here is code for list heade that is in Backup. It just show header information.
Syntax:
RESTORE HEADERONLY FROM DISK='path of your backup file'
EXAMPLE:
RESTORE HEADERONLY 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