Showing posts with label RESTORE HEADERONLY in SQLSERVER 2005. Show all posts
Showing posts with label RESTORE HEADERONLY in SQLSERVER 2005. Show all posts

Wednesday, October 27, 2010

Show header form Data Base backup with out backup restoration

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.