Posted By

gdelgado on 04/25/12


Tagged


Versions (?)

DBGrowthHistoryViaBackupHistory


 / Published in: SQL
 

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

Report this snippet  

You need to login to post a comment.