Have an older but large db (6tb on the san) that still has its page verification option set to TORN_PAGE_DETECTION. How do you apply the new checksum to all existing pages when changing page verification to checksum mode? Is there any big overhead to be wary of when making this change to page verification mode? Does this need to be done during a long maintenance window?
SQL 2014 Current DB Compat Level = 120