Skip to content

Instantly share code, notes, and snippets.

@kristinaconley
Created May 5, 2016 20:04
Show Gist options
  • Save kristinaconley/1de7fb3b354f4fc247852d107925216e to your computer and use it in GitHub Desktop.
Save kristinaconley/1de7fb3b354f4fc247852d107925216e to your computer and use it in GitHub Desktop.
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.backupmediafamily.device_type,
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)) >= '5/4/2016'
AND msdb.dbo.backupset.database_name = 'Radiant'
ORDER BY
CASE msdb..backupset.type
WHEN 'D' THEN 'Database'
WHEN 'L' THEN 'Log'
END ,
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