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.

asked 08 Apr '13, 20:24

Nick%20Brooks's gravatar image

Nick Brooks
513171931
accept rate: 50%

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?

(09 Apr '13, 03:38) Volker Barth
Replies hidden

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!

(10 Apr '13, 22:14) Nick Brooks
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • 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:

×25
×22

question asked: 08 Apr '13, 20:24

question was seen: 706 times

last updated: 10 Apr '13, 22:14