1 2 3 4 5 6 7 8 9 10 11 12 13 14
| -- récupérer des informations sur les dernières sauvegardes effectuées
SELECT CONVERT(VARCHAR(100), SERVERPROPERTY('Servername')) AS Instance, BUS.database_name, BUS.backup_start_date
, CONVERT (VARCHAR(10), BUS.backup_finish_date - BUS.backup_start_date, 108) AS duration
, CASE BUS.type WHEN 'D' THEN 'Database' WHEN 'L' THEN 'Log' WHEN 'I' THEN 'Differential database'
WHEN 'F' THEN 'File or filegroup' WHEN 'G' THEN 'Differential file' WHEN 'P' THEN 'Partial'
WHEN 'Q' THEN 'Differential partial' ELSE BUS.type END AS backup_type_desc
, BUS.compressed_backup_size/1048576.0 as backup_size_mo
, CASE WHEN BUS.compressed_backup_size = BUS.backup_size THEN 0 ELSE 1 END compressed_backup
, CAST(100*BUS.compressed_backup_size/BUS.backup_size AS DECIMAL(5,2)) AS CompressionRatio
, BUMF.physical_device_name, BUS.name AS backupset_name
FROM msdb.dbo.backupmediafamily BUMF
INNER JOIN msdb.dbo.backupset BUS ON BUMF.media_set_id = BUS.media_set_id
-- WHERE CONVERT(datetime, BUS.backup_start_date, 102) >= GETDATE() - 7
ORDER BY BUS.backup_finish_date desc , BUS.database_name |
Partager