backupmediaset (Transact-SQL)

Contains one row for each backup media set. This table is stored in the msdb database.

Column name Data type Description

media_set_id

int

Unique media set identification number. Identity, primary key.

media_uuid

uniqueidentifier

The UUID of the media set. All Microsoft SQL Server 2005 media sets have a UUID.

For earlier versions of SQL Server, however, if a media set contains only one media family, the media_uuid column might be NULL (media_family_count is 1).

media_family_count

tinyint

Number of media families in the media set. Can be NULL.

name

nvarchar(128)

Name of the media set. Can be NULL.

For more information, see MEDIANAME and MEDIADESCRIPTION in BACKUP (Transact-SQL).

description

nvarchar(255)

Textual description of the media set. Can be NULL.

For more information, see MEDIANAME and MEDIADESCRIPTION in BACKUP (Transact-SQL).

software_name

nvarchar(128)

Name of the backup software that wrote the media label. Can be NULL.

software_vendor_id

int

Identification number of the software vendor that wrote the backup media label. Can be NULL.

The value for Microsoft SQL Server is hexadecimal 0x1200.

MTF_major_version

tinyint

Major version number of Microsoft Tape Format used to generate this media set. Can be NULL.

mirror_count

tinyint

Number of mirrors in the media set. For media sets that exist at the time of upgrade to SQL Server 2005, the mirror count is 1.

is_password_protected

bit

Is the media set password protected:

0 = Not protected

1 = Protected

See Also

Reference

backupfile (Transact-SQL)
backupfilegroup (Transact-SQL)
backupmediafamily (Transact-SQL)
backupset (Transact-SQL)
System Tables (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance