Twit This!
Create Proc GTrack (@DBName varchar(40))
AS
Select @DBName as [Growth Track of database]
Select BackupDate = convert(varchar(10),backup_start_date, 111) ,SizeInGigs=floor( backup_size/1024000000) from msdb..backupset where database_name = @DBName and type = 'd' order by backup_start_date desc
--EXEC GTrack 'PUBS'
This entry was posted
on Monday, June 16, 2008
at Monday, June 16, 2008
and is filed under
SQL Queries
. You can follow any responses to this entry through the
comments feed
.
_507_Rez.jpg)
