SQL Log error  
Author Message
nexwave999





PostPosted: Thu Dec 13 06:53:01 PST 2007 Top

SQL Server >> SQL Log error

I have 20+ small databases (500mb each) running on a server.
.
Upon checking the sql error logs, I see this message.
.
2007-12-11 15:01:11.49 spid2s A page that should have been constant has
changed (expected checksum: 7ddce67b, actual checksum: 7ddcc67b, database 8,
file 'C:\sql_data\CustomerDB.mdf', page (1:45524)). This usually indicates a
memory failure or other hardware or OS corruption.
.
I have never seen anything like this before. This is the only database out
of the 20 reporting this error. Has anyone run into this, and if so, can
you please tell me the steps you took to resolve the issue?
.
Thank you for your time.

SQL Server274  
 
 
Karthik





PostPosted: Thu Dec 13 06:53:01 PST 2007 Top

SQL Server >> SQL Log error Did you try running a DBCC CHECKDB command on the culprit database? If not do
try it and report the results.

Regards,
Karthik



> I have 20+ small databases (500mb each) running on a server.
> ..
> Upon checking the sql error logs, I see this message.
> ..
> 2007-12-11 15:01:11.49 spid2s A page that should have been constant has
> changed (expected checksum: 7ddce67b, actual checksum: 7ddcc67b, database 8,
> file 'C:\sql_data\CustomerDB.mdf', page (1:45524)). This usually indicates a
> memory failure or other hardware or OS corruption.
> ..
> I have never seen anything like this before. This is the only database out
> of the 20 reporting this error. Has anyone run into this, and if so, can
> you please tell me the steps you took to resolve the issue?
> ..
> Thank you for your time.
>
>
>
 
 
TheSQLGuru





PostPosted: Thu Dec 13 10:06:06 PST 2007 Top

SQL Server >> SQL Log error Please don't multi-post.

--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.




>I have 20+ small databases (500mb each) running on a server.
> .
> Upon checking the sql error logs, I see this message.
> .
> 2007-12-11 15:01:11.49 spid2s A page that should have been constant
> has changed (expected checksum: 7ddce67b, actual checksum: 7ddcc67b,
> database 8, file 'C:\sql_data\CustomerDB.mdf', page (1:45524)). This
> usually indicates a memory failure or other hardware or OS corruption.
> .
> I have never seen anything like this before. This is the only database
> out of the 20 reporting this error. Has anyone run into this, and if so,
> can you please tell me the steps you took to resolve the issue?
> .
> Thank you for your time.
>