November 24, 2008 at 5:51 am
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?
November 24, 2008 at 8:19 am
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.
November 27, 2008 at 10:38 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply