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 = ‘Database_Name’
ORDER BY backup_finish_date DESC
Note: Please test scripts in Non Prod before trying in Production.
Loading...
Nihitha
Really good
Nikitha
Good Article very use ful