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.
source to share