Hi, I am using SQL Litespeed for taking backups. I am facing one strange issue with the physical_device_name column values in msdb.dbo.backupmediafamily table. In one of the SQL Servers (version is SQL 2005 SP2), I am taking are 3 transaction log backups generated in sequence from one of the database generated with media_set_id (from msdb.dbo.backupset) as 82945,82955,82968. In order to see the physical_device_name of the backups, I executed the following: select media_set_id, physical_device_name from msdb.dbo.backupmediafamily where media_set_id in (82945,82955,82968) order by media_set_idoutput is as follows: media_set_id physical_device_name82945 \BOMDBEDBPV001MSSQL_DBATranlogsIND_VDI_PRDIND_VDI_PRD_tlog_20091214_1600_LSP.bak82955 VDI_634CF06E-83F8-4A6D-8CAE-0A12E379FD93_0 82955 VDI_634CF06E-83F8-4A6D-8CAE-0A12E379FD93_182968 \BOMDBEDBPV001MSSQL_DBATranlogsIND_VDI_PRDIND_VDI_PRD_tlog_20091214_1630_LSP.bak I am not getting what is VDI_634CF06E-83F8-4A6D-8CAE-0A12E379FD93_0 and VDI_634CF06E-83F8-4A6D-8CAE-0A12E379FD93_1. For media_set_id 82945 and 82968, the physical_device_name is a path of fille, then why is there a different type of value shown for 82955 when the script is same and both the backups are taken using SQL Litespeed. Regards, Chetan
As you are using third party tool, why not refer to that vendor's site and I'm sure there will be a notification or blog to help you.