Posted By


gdelgado on 04/25/12

Tagged


Statistics


Viewed 81 times
Favorited by 0 user(s)

DBGrowthHistoryViaBackupHistory


/ Published in: SQL
Save to your folder(s)



Copy this code and paste it in your HTML
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.