I've just come across this post, whilst investigating a similar situation (though legacy).

Can anyone explain what potential issues there are (if any) in changing a production database from TORN_PAGE_DETECTION to CHECKSUM?

Am I right in assuming that CHECKSUM can't be implemented retrospectively anyhow, and so it will only affect new pages, and therefore that I am safe to make this change?

Thanks

Andy