SQL Anwyhere: 126.96.36.19917 OS: Windows 2008 64bit
Q: Does anyone have any ideas as to why some validations pass, whilst others return an orphaned page error?
We got notified about an orphaned page error in our nightly validation (on the PM backup):
Orphaned page (001ff99a) found in database file "[location]"
The next day we ran the validation on the AM backup (occurred after the previous PM backup) and no errors were reported.
The next nightly validation occurred without any errors, however the nightly validation after that reported another orphaned page error:
Orphaned page (001efe92) found in database file "[location]"
We have finally run the validation on the actual database, and it did report an orphaned page (we shall be performing a rebuild), however we are curious as to why validation could have returned different results.
asked 08 Apr '13, 20:24