Showing posts with label w2000. Show all posts
Showing posts with label w2000. Show all posts

Monday, March 26, 2012

Error 823

I'm running W2000 server with SQL 7.0 SP2. we get the following error

Error 823, severity 24, state 1 , i/o error (bad page 10) detected
during read of BUF pointer= 0x11959fc80, page ptr=0x45724000, page id=
(0x3:0x777f), dbid=7, status= 0x 801, file=D:\masdata\monitordb.ndf

We continued restoring a backup, but after a few day, the database crash again.Microsoft has reported to fix this error in service pack 3,

FIX: Error 823 or 8966 Reported by SQL Server with Insufficient System Resources

Knowledge base article Q274310sql