/ Published in: SQL
- --Script to query db growth history using backup history this is accurate as long as there's no compression involved.--
- 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
You need to login to post a comment.