823 Error

[tangrh]

I had a suspected database,when SQL Server tried to start it,an error occured said that 823 error,and the book online say that maybe some disk error on its file,but I am sure no disk error.The error message say "Bad page ID",What can i do?How can I recover the database,if somebody know,please help me,you may send an email to tangrh@21cn.com,thank you.

Error: 17805, Severity: 18, State: 3
2002-09-28 13:16:56.06 ods Invalid buffer received from client..

0 transactions rolled back in database 'renzw' (8).

2397 transactions rolled forward in database 'renzw' (8).

Error: 3414, Severity: 21, State: 1
Database 'renzw' (database ID 8) could not recover. Contact Technical Support.

Error: 3313, Severity: 21, State: 2
Error while redoing logged operation in database 'renzw'. Error at log record ID
(20347:22029:5).

Error: 823, Severity: 24, State: 1
I/O error (bad page ID) detected during read of BUF pointer = 0x11842840, page p
tr = 0x21a22000, pageid = (0x1:0x2c28a), dbid = 8, status = 0x801, file = e:\mssq
l7\data\renzw.mdf.

[rmiao]

Seems db file crushed. Check windows event log to see if any disk related errors there. May have to restore from good backup.

[tangrh]

Thank you rmiao.I don't think it's a disk error,even though bookonline says so.I think it maybe something error on
this page(pageid = (0x1:0x2c28a) ),and SQL Server can't rollback transaction on this page,because its data was damaged.If we can recover this db without this page(even lose data on this page),then we can recover the db,but we do not know how to do it.

[rmiao]

One thing you can try is set db to emergency mode then run dbcc to check db.