Advanced Search

Return to Snippet

Revision: 56931
at April 25, 2012 12:11 by gdelgado
Initial Code 
--Script to query db growth history using backup history this is accurate as long as there's no compression involved.--

select 
database_name, 
BackupDate = convert(varchar(10),backup_start_date, 111) 
,SizeInGigs=( backup_size/1024000000) 
from msdb..backupset 
where database_name = 'FRD' and
type = 'd'
order by database_name, backup_start_date asc
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
DBGrowthHistoryViaBackupHistory

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL