SQL Anwyhere: 11.0.1.2817 OS: Windows 2008 64bit Q: Does anyone have any ideas as to why some validations pass, whilst others return an orphaned page error? Details: 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. |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 08 Apr '13, 20:24
question was seen: 1,858 times
last updated: 10 Apr '13, 22:14
Recently, we had problems with a MS SQL Server database which returned strange (and varying) error messages when running "DBCC CHECKDB" - one run was OK, the next (immediately afterwards) showed several errors, and so on. Copying the database to another server did not show any errors. - In the end, the effect went away after the server's RAM was exchanged... - have you checked whether these errors are shown on different hardware, as well?
Thanks @Volker. We've scheduled an outage to grab the prod database and bring it down to a lower region to try dbvalid. Worth mentioning, that the past two nights validation have succeeded! Very frustrating!