Quote:
Originally Posted by ownedbycats
What exactly does the "page #### is never used" error (corrupt database) actually mean? Compressing the database fixed it.
|
It means an internal page mapping is out of sync. Basically, one place has pointer say that a page in the file is used, but, none of the tables or indexes are actually using the page. Here, "page" is basically the unit of allocation of disk space in the file. It should be safe to ignore.
The compress, or VACUUM, rebuilds the file. So, it cleans up any unused space.