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
No comments:
Post a Comment