Jump to content


Integrity check results - what do they mean?

  • Please log in to reply
1 reply to this topic

#1 snowathlete


    Advanced Member

  • Members
  • PipPipPip
  • 63 posts

Posted 28 February 2014 - 06:55 PM

Just ran an integrity check, and got this:
Integrity check results:

*** in database main ***
Page 1151 is never used
Page 36098 is never used

What does this mean?
I'm guessing it isn't that serious. I ran the other database tools then reran the integrity check and all was ok.

#2 TomH


    Advanced Member

  • Members
  • PipPipPip
  • 6415 posts

Posted 28 February 2014 - 10:49 PM

It is a report from the database engine SQLite from tests that it carries out on the state of the database file. I don't think an unused page is in any way a concern but I could be wrong. There are other more worrisome messages. While the other database tools may eliminate such messages, it is not a guarantee that nothing was lost. It's a good idea to do the integrity check periodically - it may catch degradation in your hard drive or some other aberration.

Tom user of RM7630 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com
SQLite_Tools_For_Roots_Magic_in_PR_Celti wiki, exploiting the database in special ways >>> RMtrix-tiny.png app, a bundle of RootsMagic utilities.