In this article I am sharing a simple T-SQL code to track database growth for specific database. This could be a very simple query for SMEs but it can really help newbies:
/*************************************************
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
/*************************************************
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
Hi,
Thanks for your visit to this blog.
We would be happy with your Queries/Suggestions.