Technical Article

Easy and Fast way to check Backup details

,

Easy and Fast way to check Backup details. One line query to check backup status for all the databases. No need to go to each database or schedule job. Even you can use this query in customized application to get all the details on a single screen.

/*
Easy & Fast way to check Backup details

Mohit Nayyar - Mohit_SME@yahoo.com
*/
USE msdb
go
SELECT Server_Name, Database_Name, CASE Type WHEN 'D' THEN 'Full' WHEN 'L' THEN 'Transaction Log' WHEN 'I' THEN 'Differential' WHEN 'F' THEN 'FileGroup' END AS Backup_Type, max(database_creation_date) as DB_Creation_Date, max(backup_finish_date) as Last_Backup_Date
FROM backupset
GROUP BY server_name, database_name, Type
ORDER BY 1,2

Rate

5 (1)

You rated this post out of 5. Change rating

Share

Share

Rate

5 (1)

You rated this post out of 5. Change rating