Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Error 823

Author  Topic 

mr_mist
Grunnio

1870 Posts

Posted - 2004-03-15 : 05:10:52
Hi I am getting the error message 823 bad page ID during read .. when I'm trying to CREATE DATABASE on one of our servers.

The help file suggests that there should be messages in the event viewer or logs to identify the exact problem but there are no such messages.

What can I do to get around this issue? Does this always indicate disk failure?

-------
Moo. :)

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2004-03-15 : 06:22:19
check this out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;828339

He is a fool for five minutes who asks , but who does not ask remains a fool for life!
Go to Top of Page

mr_mist
Grunnio

1870 Posts

Posted - 2004-03-15 : 08:24:12
Thanks, that's given a few possibilities to look at.

-------
Moo. :)
Go to Top of Page

JohnDeere
Posting Yak Master

191 Posts

Posted - 2004-03-15 : 09:46:09
I was getting a lot of 823 torn page errors. After working with Micro soft it was determined that the cache on the disk controller was conflicting with sql servers caching system. We disabled the cache and have not had any errors since.

Lance Harra
Go to Top of Page
   

- Advertisement -