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

No comments:

Post a Comment