/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
--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