Consistency errors

  • Hi!

    I got a problem with av database(SharePoint 2007) that when i check it by running CHECKDB when the database is online everything is ok no allocation errors and no consistency errors, but when i take a backup and restore it to another database server CHECKDB reports:

    There are xrows in xpages for object "AllDocStreams".

    CHECKDB found 0 allocation errors and 4 consistency errors in table 'AllDocStreams' (object ID x).

    Its an virtual enviroment(VMWare) so we have tryed to move the whole virtual enviroment to, but the strange thing is that when we try this the same error occurs in the database!

    Could the CHECKDB report wrong while the database is online or any other suggestions?

    Thanks in advance!

    /Thomas

  • Try taking the backup WITH CHECKSUM, it could be getting damaged during backup, after backup when it's copied. Could also be the destination server is mangling the data during/after restore.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Ok, thanks for the reply we are going to try CHECKSUM and get back with results.

    /Thomas

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply