Home > database >  Sybase dump backup data suggest Page mismatch...?
Sybase dump backup data suggest Page mismatch...?

Time:09-16

Nov 18 14:50:57 2018: D00: Page Verification Error: Page mismatch. The Page contains 1426 to 125312636 in Page header.
Nov 18 14:50:57 2018: D00: Page Verification Error: Page mismatch. The Page contains 1427 to 1397255802 in Page header.
Nov 18 14:50:57 2018: D00: Page Verification Error: Page mismatch. The Page contains 1428 to 1549687896 in Page header.
Nov 18 14:50:57 2018: D00: Page Verification Error: Page mismatch. The Page contains 1429 to 1393780009 in Page header.
Nov 18 14:50:57 2018: D00: Page Verification Error: Page mismatch. The Page contains 1430 to 18120282 in Page header.
Nov 18 14:50:57 2018: D00: Page Verification Error: Page mismatch. The Page contains 1431 to 974079030 in Page header.
Nov 18 14:50:57 2018: D00: Page Verification Error: Page mismatch. The Page contains 1450 to 578777212 in Page header.
Nov 18 14:50:57 2018: D00: Page Verification Error: Page mismatch. The Page contains 1451 to 352665367 in Page header.
Nov 18 14:50:57 2018: D00: Page Verification Error: Page mismatch. The Page contains 1452 to 1247496279 in Page header.
Nov 18 14:50:57 2018: D00: Page Verification Error: Page mismatch. The Page contains 1453 to 1233013355 in Page header.
Nov 18 14:50:57 2018: D00: Page Verification Error: Page mismatch. The Page contains 1454-2051185069 in the Page header.
Nov 18 14:50:57 2018: D00: SYBMULTBUF WARNING: One or more errors have had reported while performing consistency checks on the pages being dumped. The affected pages will be reread in an attempt to discard spurious errors.
Nov 18 14:50:57 2018: D00: SYBMULTBUF WARNING: After rereading the pages, and the consistency check has continued to report one or more errors.

CodePudding user response:

DB has bad page in the history of the storage hardware, hurry up DBCC checkdb or checktable... Then can dballoc (... Fix) quickly, trim, then hurriedly BCP out all the table can save save first down

CodePudding user response:

reference 1st floor EisenWang response:
DB bad page storage hardware, quickly DBCC checkdb or checktable... Then can dballoc (... Fix) quickly, trim, then hurriedly BCP out all the table can save save first down.
thank you
  • Related