Database Trend Analysis.
A common question that a DBA gets asked is to find out the what is the database growth like. A easy way to get this is run the query below select database_Name, backup_start_date, backup_size, ((backup_size/1024.0)/1024.0)/1024.0 'Size In GB' from Msdb.dbo.backupset where database_name = 'MyDatabase' and type = 'D' order by Backup_start_date this database query will give you the size of the backup sets, which then sets the stage to do a proper trend analysis on the databases. Happy coding.