DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Damage of the SQL database

  1. #1
    Join Date
    Aug 2015
    Posts
    2

    Damage of the SQL database

    Good day, friends!
    There is the following situation. On one server, I make a backup of the database. With integrity check everything is carried out. Transfer the backup to another server and restore from it base, has also successfully completed. I do a couple of selects from the tables just in case, selects are work. After that didn't touch base. Suddenly after a few hours started pouring in an error like
    Table error: alloc unit ID 72057606917455872, page (1:1163817) contains an incorrect page ID in its page header. The PageId in the page header = (1:8696745).
    Doing DBCC CHECKDB but it fails.
    Msg 7985, Level 16, State 2, Line 1
    System table pre-checks: Object ID 3. Could not read and latch page (1:1163817) with latch type SH. Check statement terminated due to unrepairable error.

    DBCC results for 'DWH_Globus'.
    Msg 5256, Level 16, State 1, Line 1
    Table error: alloc unit ID 72057606917455872, page (1:1163817) contains an incorrect page ID in its page header. The PageId in the page header = (1:8696745).

    CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
    CHECKDB found 0 allocation errors and 1 consistency errors in database 'DWH_Globus'.
    ObjectId 3 - system table. I don't know how it could be damaged. To SAN there were no errors. In Event Viewer there are no errors, except these.
    ОС - WinServer 2012 R2, SQL Server 2012 SP2 CU4 EE.
    Except me nobody touched base. Prompt, please, because of what such can happen not to run on the same mistakes next time.

  2. #2
    Join Date
    Aug 2015
    Posts
    1
    If errors started pouring, it says that a problem not on one page. The most objective test it is to deploy the database on another server and do the test there. If there everything is normal - that a problem in PC. See if the following article would help: https://community.office365.com/en-us/f/172/t/266070

  3. #3
    Join Date
    Aug 2015
    Posts
    2
    Thank you all for your advice! The issue has been resolved.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width