msdb..backupfile table in SQL 2019

Copper Contributor

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. 

0 Replies