Backup list

October 4th, 2016

Backup rows by month

select convert(varchar(7), backup_finish_date, 120)  AS backup_month, COUNT(*) as backup_rows from msdb.dbo.backupset
	group by convert(varchar(7), backup_finish_date, 120)
	order by convert(varchar(7), backup_finish_date, 120);


Comments are closed.