I have a SQL Server database with the
PAGE_VERIFY option set to
NONE. When I set this to
CHECKSUM, only pages changed from that point onwards get their checksum calculated and stored on the page.
I'm looking for the best way to put checksums on at least all table and index data.
My initial idea would be to drop and recreate all clustered indexes. For tables that have no clustered index I would create one and then drop it again.
That should result in at least one write operation on each data and index page, but it's a bit heavy-handed. Anyone has a better idea?