Pessoal, consegui resolver da seguinte forma:
/*
Author: Douglas R. de Oliveira
Date: 10/07/2012
Desc: Consulta para trazer o histórico de crescimento das bases de dados.
Essa consulta é baseado sobre os backups que são realizados diariamente, e do tipo FULL.
Email: douglasro@gmail.com
*/
SELECT b.database_name,
min(bf.file_size) AS "Initial size",
max(bf.file_size) AS "Final size",
year(b.backup_start_date) AS "Year",
month(b.backup_start_date) AS "Month"
FROM backupset b
INNER JOIN backupfile bf ON b.backup_set_id = bf.backup_set_id AND bf.file_type = 'D'
WHERE b.name = 'full'
AND b.backup_start_date BETWEEN '2011-01-01' AND '2011-12-31'
AND b.database_name = 'database'
GROUP BY b.database_name, year(b.backup_start_date), month(b.backup_start_date)
ORDER BY 4
Para mim é bem útil.
[]'s Douglas R. Oliveira
