• Search for:

    Monthly Archives: September 2022

    1. Home  - 2022  - 
    2. September
    27 Sep, 2022
    T-SQL query to check last Full, Differential and Log Backup Times 0 (0)
    MSSQL, T-SQL Scripts , , , ,

    Below query can be used to check last full, differential and transaction log backup times in SQL Server.

    SELECT sd.[Name] AS DatabaseName,
    LastFullBackUpTime=(SELECT MAX(bs.backup_finish_date) FROM msdb.dbo.backupset bs WHERE
    bs.[database_name]=sd.[name] AND bs.[type]='D'),
    LastDiffBackUpTime=(SELECT MAX(bs.backup_finish_date) FROM msdb.dbo.backupset bs WHERE
    bs.[database_name]=sd.[name] AND bs.[type]='I'),
    … Read the rest