Community

How Much Data Has Changed Since Your Last Full Backup

(Greg Larsen) Have you ever wanted to know how many pages in your database have changed since the last full backup? If so, then you will be glad to hear that SQL Server 2017 version of the DMV sys.dm_db_file_spavce_usage has a new column named modified_extent_page_count.


Read More (Community content)