Backups das Bases de Dados

Backups das Bases de Dados

Query para verificação do backup das bases de dados do Verint:
WITH LatestBackups AS (
    SELECT 
        bs.database_name,
        CASE bs.type
            WHEN 'D' THEN 'Full'
            WHEN 'I' THEN 'Differential'
            WHEN 'L' THEN 'Log'
            ELSE bs.type
        END AS [Backup Type],
        bs.backup_start_date,
        bs.backup_finish_date,
        bmf.physical_device_name,
        ROW_NUMBER() OVER (PARTITION BY bs.database_name ORDER BY bs.backup_start_date DESC) AS rn
    FROM 
        msdb.dbo.backupset bs
    INNER JOIN 
        msdb.dbo.backupmediafamily bmf 
        ON bs.media_set_id = bmf.media_set_id
)
SELECT 
    database_name,
    [Backup Type],
    backup_start_date,
    backup_finish_date,
    physical_device_name
FROM 
    LatestBackups
WHERE 
    rn = 1
ORDER BY 
    backup_start_date DESC;