Monday, 19 May 2014

How to find the DB Growth in sql server(simple way to find out the db growth in sql server)
------------------------------------------------------------------------------------------
select 
 BackupDate = convert(varchar(10),backup_start_date, 111) 
 ,SizeInGigs= convert(  varchar(20),backup_size/1000000)
 ,database_name
from msdb..backupset 
where 
 database_name = 'PGAccruals'
 and type = 'd'
order by 
 backup_start_date desc