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'
Monday, June 16, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment