Psst! Did you know DevelopmentNow is a mobile web site design agency?

Contact us for help mobilizing your site, or to sign up for our beta Mobile Web SDK!
all groups > sqlserver server > november 2004 >

sqlserver server : device_type = 7 in backupmediafamily?


pnwdoug NO[at]SPAM yahoo.com
11/10/2004 5:38:29 PM
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_a65daaac40b9_").
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,
AnthonyThomas
11/10/2004 6:39:01 PM
Looks like a virtual_device used to create backups using the VBDI API. The
Veritas SQL Server client uses this among others.

Sincerely,


Anthony Thomas

[quoted text, click to view]
AddThis Social Bookmark Button