January 26, 2012 at 6:18 am
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
January 26, 2012 at 6:39 am
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
February 9, 2012 at 1:11 am
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