possible data corruption?

  • getting the following 4 errors when attemping to do a weekly reindex of one of my databases. We just moved to a new Server this weekend because of corruption on the SAN.. but all the DBs checked out after the move..

    Attempt to fetch logical page (1:168576) in database 'SDHelpDeskDB' belongs to object '1797637899', not to object 'ITSM_HIST_INFO_SERVICECALL'..

    Error: 605, Severity: 21, State: 1

    IAM indicates that page is allocated to this object

    (1:168576)/(1:168576)1797637899/64557733

  • Run a checkDB on that database, see if you have any other errors. How old is your most recent backup?

    You said the databases were fine after the move off the old SAN. How did you check them?

    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

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

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