Usage of RESTORE HEADERONLY

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.
Ebook Download
View all
Learn
View all