Bookmark and Share
Check backup history
(Publish Date: 2014-5-21 5:17pm, Total Visits: 497, Today: 1, This Week: 1, This Month: 4)

-- Check backup history

USE msdb;
GO

SELECT
    bs.media_set_id,
    bs.backup_finish_date,
    bs.backup_size,
    bs.compressed_backup_size,
    mf.physical_device_name
FROM dbo.backupset AS bs
INNER JOIN dbo.backupmediafamily AS mf
ON bs.media_set_id = mf.media_set_id
WHERE database_name = 'AIS'
ORDER BY backup_finish_date DESC;
GO


-- deletes all history prior to the date provided

USE msdb;
GO

EXEC sp_delete_backuphistory @oldest_date = '20140201';
GO