Hello we had some power surges and unfornately one of our cliens database got corrupted and went to suspect\offline mode automatically. I tried to bring online and it gives me this Error
"Error 823:I\O error(bad page ID) detected during read of BUF pointer=0X11c10400,page ptr=0X1f920000,pageid=(0X1:0x2),............ 416 transanctions rolled forward in database 'xxxx'(20)"
Unfortunately the last backup made was on 2004..Is there anyway to fix this database? any disaster recovery or where you pay to get this db fixed. The rest of the databases are working fine. Also I'm using an old Sql server 7. Any settings I have to reset /refresh on sql server 7? please guide me..
Take a backup of thedata files first. You can send them away for data recovery - a few companies including microsoft will do thuis.
>> Unfortunately the last backup made was on 2004 They get very little sympathy for that.
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.
Someone should lose their job over this. Not having a backup in 2 years is unacceptable. Imagine the look on the faces of upper management when they hear that part.
Cannot bring Database Online: Urgent :)
Posted - 10/04/2006 : 12:09:44
