Skip to content
ERIC BLINN

Just another SQL Blog by just another DBA

Primary Navigation Menu
Menu
  • Home
  • Presentation Materials
  • About Me

corruption

Corruption Series: #3 Page Verification during backups

2018-12-18
By: Eric Blinn
On: December 18, 2018
In: Uncategorized
With: 1 Comment

We left off the last post with 2 equally corrupted databases. One database had page checksums enabled and the other did not. We learned that upon reading the corrupt page, the checksum was recalculated, compared, and if unmatched, threw an exception. But what if the page that was corrupted isn’t read for a period of time? Maybe the page that has been corrupted is part of an older record that isn’t often read. Certainly a DBCC CheckDB command will find it, but we want to find out even sooner. It turns out the page checksums are again able to help us as we can askRead More →

Recent Posts

  • The future of the Ohio North SQL Server User Group
  • Hiatus
  • Corruption Series: #3 Page Verification during backups
  • Corruption Series: #2 Page Verification
  • Corruption Series: #1 Making Corruption

Recent Comments

  • Backups With Checksum Validation – Curated SQL on Corruption Series: #3 Page Verification during backups
  • Corrupting Databases For Fun And Profit – Curated SQL on Corruption Series: #1 Making Corruption
  • What Prevents Plan Reuse? – Curated SQL on When is a plan not able to be reused?
  • Smarter Indexes Based On Column Cardinality – Curated SQL on Making smarter indexes
  • Brent Ozar on Making smarter indexes

Archives

  • September 2020
  • March 2019
  • December 2018
  • November 2018
  • October 2018
  • August 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • September 2017
  • August 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016

Categories

  • Basics
  • configuration
  • DMVs
  • dynamic sql
  • indexes
  • optimizer
  • query plans
  • query tuning
  • Reporting
  • SQL Server
  • t-sql
  • trace flags
  • tsqltuesday
  • Uncategorized

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Designed using Dispatch. Powered by WordPress.