Event 832 error

  • Hi all;

    Just noticed an error in the application event log of our local development server, which is running MS SQL Server 2005. It's event 832,

    A page that should have been constant has changed (expected checksum: c4270e9f, actual checksum: 59620e3f, database 244, file 'F:\MSSQL\TAQA_NORTH_DATA.mdf', page (1:57452)). This usually indicates a memory failure or other hardware or OS corruption.

    Can anyone please provide any additional diagnostic ideas or links to other information?

    how i RESOLVE IT?

  • It's what it says. it usually indicates some hardware issue.

    You can try rebooting, but if you got this again, I'd call Microsoft and have them help diagnose this. There aren't a lot of tools to use and I would be very, very careful about how I proceeded here.

  • I'd recommend you run a checkDB on that database asap. Make sure your backups are available and you know what your recovery options are. How long have you been getting this error?

    Are there any entries in the system event log? Anything to indicate hardware (IO system) problems?

    DBCC CHECKDB ('< Database Name > ') WITH NO_INFOMSGS, ALL_ERRORMSGS

    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 3 posts - 1 through 2 (of 2 total)

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