Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shehz
Starting Member
10 Posts |
 Posted - 2006-10-04 : 12:09:44
|
| 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..Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-10-04 : 12:25:11
|
| seehttp://www.nigelrivett.net/SQLAdmin/RecoverCorruptDatabase.htmlTake 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 2004They 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. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-04 : 14:46:35
|
| "The rest of the databases are working fine"if you haven't done so already I recommend run:DBCC CHECKDB('database_name') WITH NO_INFOMSGSon each one to make sure that there are no corruptions.Kristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-04 : 14:50:24
|
| 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.Tara Kizer |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-04 : 14:59:10
|
Might have been a typo ... might have been 20:04 yesterday?  |
|
|
|
shehz
Starting Member
10 Posts |
Posted - 2006-10-05 : 15:39:21
|
| Thanks for the suggestion guys. I agree it is pathetic not to have a backup. I"m actually cleaning up my former developers mess. |
|
|
|
|
|
|
Cannot bring Database Online: Urgent :)