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..