Usage of RESTORE HEADERONLY

RESTORE HEADERONLY allows us to see all the backup information of a database backup.

We can use RESTORE HEADERONLY to see details of a database backup. Syntax: RESTORE HEADERONLY FROM DISK = N'Backup Path'. It will list details of the backup like DatabaseName, version, server name etc.So use this command before restoring a database from a backup. We need CREATE DATABASE permission to issue this command in SQL Server 2008.