SQL Server Backup Set "Description"

When manually backing up a database in SQL Server 2008, there is an area to enter a Description for the backup set (below Name)

But how do I revi开发者_StackOverflowew the description when restoring a database?

I'm not sure if there is a way of getting it to show up in the UI. It seems to be viewable in the msdb.dbo.backupset table.

If you're trying to read the description from a backup created on a different server, you can't use the backupset table. Instead, use:

RESTORE HEADERONLY FROM DISK = 'C:\myfile.bak'

The BackupDescription column will contain the description: