dm_io_backup_tapes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
physical_device_name nvarchar 520 null
logical_device_name nvarchar 256 √ null
status int 4 null
status_desc nvarchar 520 null
mount_request_time datetime 16,3 √ null
mount_expiration_time datetime 16,3 √ null
database_name nvarchar 256 √ null
spid int 4 √ null
command int 4 √ null
command_desc nvarchar 120 √ null
media_family_id int 4 √ null
media_set_name nvarchar 256 √ null
media_set_guid uniqueidentifier 16 √ null
media_sequence_number int 4 √ null
tape_operation int 4 √ null
tape_operation_desc nvarchar 120 √ null
mount_request_type int 4 √ null
mount_request_type_desc nvarchar 120 √ null

Relationships

Close relationships within degrees of separation