Did you track the growth of your database-backup?

Frequently you'll want to know how fast your database-backup has been growing. Perhaps you have implement a SAN Backup-Device for Backup-to-disk, or you only want know how fast your database has been growing.

This TSQL statement will query the [msdb]..[backupset], to roughly outline the growth of your database-backup, for each user-database of the local server.

DECLARE @command VARCHAR(1000)
CREATE TABLE #db_backup_grow (DBName sysname, BackupDate sysname, SizeInGB sysname)
 
SELECT @command = 
'USE [?] SELECT ''?'' AS DBName
			,BackupDate = CONVERT(VARCHAR(10),[backup_start_date], 111)
			,SizeInGB = ([backup_size]/1073741824)
			FROM [msdb]..[backupset] 
				WHERE [database_name] = ''?'' 
					AND [type]=''D'' 
			ORDER BY [backup_start_date] DESC'
INSERT INTO #db_backup_grow
EXEC sp_MSforeachdb @command

SELECT *
FROM #db_backup_grow
	WHERE DBName not in ('master', 'model', 'msdb', 'tempdb')
ORDER BY DBName, BackupDate, SizeInGB
DROP TABLE #db_backup_grow

CU tosc

Qui tacet, consentire videtur