Forum Discussion
SK_DBA
Dec 20, 2023Copper Contributor
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