Created
December 2, 2011 03:01
-
-
Save justinpitts/1421535 to your computer and use it in GitHub Desktop.
get backup history for last 20 days
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server, | |
msdb.dbo.backupset.database_name, | |
msdb.dbo.backupset.backup_start_date, | |
msdb.dbo.backupset.backup_finish_date, | |
msdb.dbo.backupset.expiration_date, | |
CASE msdb..backupset.type | |
WHEN 'D' THEN 'Database' | |
WHEN 'L' THEN 'Log' | |
END AS backup_type, | |
msdb.dbo.backupset.backup_size, | |
msdb.dbo.backupmediafamily.logical_device_name, | |
msdb.dbo.backupmediafamily.physical_device_name, | |
msdb.dbo.backupset.name AS backupset_name, | |
msdb.dbo.backupset.description | |
FROM msdb.dbo.backupmediafamily | |
INNER JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id | |
WHERE (CONVERT(datetime, msdb.dbo.backupset.backup_start_date, 102) >= GETDATE() - 20) | |
ORDER BY | |
msdb.dbo.backupset.database_name, | |
msdb.dbo.backupset.backup_finish_date |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment