SQL Server views the 4 methods of backup set metadata.

Method 1, Restore Labelonly

Method 2, RESTORE HEADERONLY

Method 3, RESTORE Filelistonly

Method 4, Restore Verifyonly

--------------------------------------------------------------------------------------------------------------- -----------------------------------------

Backup Database Studio
to disk = ' E:\Studio.bak '
With
MediaName = ' This is MediaName ',
MediaDescription = ' This is Mediadescryption ',
Name = ' This is name ',
Description = ' This is description '
Go

Method 1, Restroe lableonly Returns a result set that contains information about the backup media identified by the given backup device.

Restore Labelonly

From disk = ' E:\Studio.bak ';

Go

Method 2, RESTORE HEADERONLY Returns a result set that contains all the backup header information for all backup sets on a specific backup device in SQL Server.

RESTORE HEADERONLY
From disk = ' E:\Studio.bak ';
Go

Method 3, RESTORE FILELISTONLY Returns a result set consisting of a list of databases and log files contained in a backup set in SQL Server.

Restore Filelistonly
From disk = ' E:\Studio.bak ';
Go

Method 4, Restore VERIFYONLY verifies the backup but does not restore the backup, checks whether the backup set is complete, and whether the entire backup is readable. However, RESTORE Verifyonly does not attempt to validate the data structure in the backup volume.

Restore Verifyonly
From disk = ' E:\Studio.bak ';
Go

SQL Server views the 4 methods of backup set metadata.