SQL Server 2005 Backup Devices

25 Oct 2006 9:26 PM

Loren Z

One of my users was equiring about this.

In SQL Server 2000 when you looked at the properties of a backup device, if
you looked at the media contents the description header would be there and
you could see the description you entered when you backed up the database.

In SQL Server 2005 you can enter a description when backing up a database to
a backup device, but when looking at the properties of the backup set you
used, under backup sets there is no description header. Is there anyway we
can view the description we enter when backing up a database to a backup
set?

6 Nov 2006 2:36 PM

Steve

Loren Z wrote:

> One of my users was equiring about this.
>
> In SQL Server 2000 when you looked at the properties of a backup device, if
> you looked at the media contents the description header would be there and
> you could see the description you entered when you backed up the database.
>
> In SQL Server 2005 you can enter a description when backing up a database to
> a backup device, but when looking at the properties of the backup set you
> used, under backup sets there is no description header. Is there anyway we
> can view the description we enter when backing up a database to a backup
> set?

USE msdb;

SELECT * FROM dbo.backupfile; --logical_name

SELECT * FROM dbo.backupfilegroup;

SELECT * FROM dbo.backupmediafamily ; -- logical_device_name

SELECT * FROM dbo.backupmediaset; --description

SELECT * FROM dbo.backupset; --name

see Books Online topic:
RESTORE HEADERONLY (Transact-SQL)