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
>
Friday, March 9, 2012
device_type = 7 in backupmediafamily?
Labels:
arestrange,
backupmediafamily,
database,
device_type,
means,
microsoft,
mysql,
oracle,
physical_device_name,
server,
sql,
table,
themsdb,
values
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment