/*************************************************
Purpose : Track Database Growth for a specific DB
Create By : Hari Sharma
**************************************************/
SELECT
BackupDate =
CONVERT(VARCHAR(10),backup_start_date, 111)
,SizeInMBs=FLOOR(backup_size/1024000)
FROM msdb..backupset
WHERE
database_name = DB_NAME() --Specify DB Name
AND type = 'd'
ORDER BY
backup_start_date desc
No comments:
Post a Comment