How do pages get updated checksum when switching page verification mode from torn page to checksum?

6 votes

1 answer

238 views

sql-server sql-server-2014 corruption checksum

                          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
                        

Asked by user2368632 (1133 rep)

Sep 18, 2020, 01:36 AM
Last activity: Sep 18, 2020, 06:10 PM

How do pages get updated checksum when switching page verification mode from torn page to checksum?

Related Questions