Forum Discussion

SK_DBA's avatar
SK_DBA
Copper Contributor
Dec 20, 2023

msdb..backupfile table in SQL 2019

Hi,

 

I used to query msdb..backupfile table to get database file level backup size or backup page counts. But in SQL 2019 backup_size column or backup_page_count columns are either 0 or showing very less value as compared to actual data. Kindly advice if there has been any changes in these tables in SQL 2019 as in earlier version we could use this table to check database file growth but in SQL 2019 this data is not of relevance for DB files growth estimation. 

No RepliesBe the first to reply

Resources