Monday, October 25, 2010

Track SQL Database Growth

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
   BackupDate =
   CONVERT(VARCHAR(10),backup_start_date, 111)
FROM msdb..backupset
   database_name = DB_NAME() --Specify DB Name
   AND type = 'd'
   backup_start_date desc

No comments:

Post a Comment

Here are few FREE resources you may find helpful.