SQL Server Performance

Strange Issue with TL Backups

Discussion in 'Third Party Tools' started by chetanjain04, Dec 15, 2009.

  1. chetanjain04 Member

    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_id
    output is as follows:
    media_set_id physical_device_name
    82945 \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
  2. satya Moderator

    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.

Share This Page