Page 2 of 14

T-SQL query to check last Full, Differential and Log Backup Times 0 (0)

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
« Older posts Newer posts »

© 2024

Theme by Anders NorénUp ↑