GilaMonster (1/21/2013)
If an index rebuild deallocated a corrupt page as part of the rebuild, the corruption would 'vanish', because it's no longer part of the allocated set of pages
Thank you, but I'm not clear on my next course of action. I've read the following links and am still unclear:
To me, it sounds like the corruption is still there and can reappear when that page or pages become "reallocated." Secondly, one of the articles tells how to enable checksums, but doesn't say how to check if they are already enabled. I've only been here less than a year, so I have no way of knowing if the database was originally created in version 2005 or if it was sooner. Thirdly, if I've only seen this once and not repeatedly, is it necessary to look into possible problems with the I/O subsystem?
Thanks for your time and help.