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 review the description when restoring a database?
A:
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.
Martin Smith
2010-06-20 22:28:48
Thanks, that's just what I needed. Very odd that you can enter it through the UI but it doesn't seem to display anywhere in the UI though.
mutex
2010-06-20 22:36:35