DBGrowthHistoryViaBackupHistory

--Script to query db growth history using backup history this is accurate as long as there's no compression involved.--
 
SELECT 
database_name, 
BackupDate = convert(varchar(10),backup_start_date, 111) 
,SizeInGigs=( backup_size/1024000000) 
FROM msdb..backupset 
WHERE database_name = 'FRD' AND
type = 'd'
ORDER BY database_name, backup_start_date ASC