Friday, March 9, 2012

device_type = 7 in backupmediafamily?

Does anyone know what device_type = 7 means in the
msdb..backupmediafamily table? The physical_device_name values are
strange (i.e., " model_00__9834ee39_40a6_4d36_9ba6_a65daa
ac40b9_").
Records for backups that I've initiated have device_type = 2 or 102
and the physical_device_name is the disk path of the backup file.
The SQL documentation shows six valid values for device_type: 2 or 102
= disk, 5 or 105 = tape, 6 or 106 = pipe.
Any insight is greatly appreciated.
TIA,
DougLooks like a virtual_device used to create backups using the VBDI API. The
Veritas SQL Server client uses this among others.
Sincerely,
Anthony Thomas
"Doug" wrote:

> Does anyone know what device_type = 7 means in the
> msdb..backupmediafamily table? The physical_device_name values are
> strange (i.e., " model_00__9834ee39_40a6_4d36_9ba6_a65daa
ac40b9_").
> Records for backups that I've initiated have device_type = 2 or 102
> and the physical_device_name is the disk path of the backup file.
> The SQL documentation shows six valid values for device_type: 2 or 102
> = disk, 5 or 105 = tape, 6 or 106 = pipe.
> Any insight is greatly appreciated.
> TIA,
> Doug
>

No comments:

Post a Comment