Microsoft SQL Server backup physical_device_name

I have configured 2 backup tasks in Microsoft SQL Server to have full and incremental backups of our database. Microsoft SQL Server version is 2008 R2.

The problem is I set up the location and so far a couple of weeks ago everything went well. The problem is that it creates these backups in a location that cannot be found. If I check the logs, everything will be fine. But there is no trace of this backup file in the target directory.

When I execute the following request, I get a strange value in the physical_device_name file:

SELECT
    physical_device_name,
    backup_start_date,
    backup_finish_date,
    backup_size/1024.0 AS BackupSizeKB
FROM msdb.dbo.backupset b
JOIN msdb.dbo.backupmediafamily m ON b.media_set_id = m.media_set_id
WHERE database_name = 'DB_NAME'
ORDER BY backup_finish_date DESC

      

These are the values ​​I get for filename:

  • {4CAE7525-44D7-4DEF-86A7-F9C7C99C013C} 3
  • {EC6FB844-832G-4A8F-BDDE-12D073383139} 3

Etc...

Any idea why this is the case and how to solve it? My initial thought was that these guides are read only. I changed this, but I saw that one of the backups from last night failed again for the same reason.

+3


source to share


1 answer


Yup. If you look at device_type (in the backupmediafamily table) you can see that it is probably a virtual device (7) and backed up by your virtual machine software.



+1


source







All Articles