| Author |
Topic |
|
hadi354
Starting Member
4 Posts |
 Posted - 2012-03-16 : 06:58:52
|
i have not any back up from data base. my db has occuerd this error when i try to open it:error 823:I/O error (bad page id)detected during read at offset ...with DBCC checkdb(mydb,repair_allow_data_loss) this error:Server: Msg 8966, Level 16, State 1, Line 1Could not read and latch page (1:17688) with latch type SH. sysobjects failed.DBCC execution completed. If DBCC printed error messages, contact your system administrator.is any way to restor my data |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2012-03-16 : 07:14:37
|
| Why don't you have backups? There is a reason backups exist in databases and you have just found it.How important is the data? I guess it can't be very as you haven't got a backup, in that case, just create a new db and re-create the objects. You do have object creation scripts, don't you? |
 |
|
|
hadi354
Starting Member
4 Posts |
Posted - 2012-03-16 : 07:51:52
|
| The data are very important and must be recovery. there is no backup data. this db is for 5 year data entery. db admin forget to start sql agent to auto back or any other Solution |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-16 : 11:13:42
|
| There's no recovery from that error, one of the critical system tables is damaged. If you don't have a backup and you can't even open the database, the database is probably a complete loss.SQL 2000 I assume?What's the error you get when you try to query the DB?--Gail ShawSQL Server MVP |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
hadi354
Starting Member
4 Posts |
Posted - 2012-03-16 : 13:05:25
|
quote:
Originally posted by GilaMonster
There's no recovery from that error, one of the critical system tables is damaged. If you don't have a backup and you can't even open the database, the database is probably a complete loss.SQL 2000 I assume?What's the error you get when you try to query the DB?--Gail ShawSQL Server MVP
exactily sql 2000when I try to query this error apeare:Server: Msg 601, Level 12, State 3, Line 1Could not continue scan with NOLOCK due to data movement.in first my db was suspect. i dettach it then my db not attach and appear this error while attaching: "the error 823:I/O error (bad page id)detected during read at offset ..."I read an article about the problem and the steps I followed it[url]http://www.sqlserverclub.com/articles/how-to-recover-from-a-corrupted-sql-server-database.aspx[/url]in 16 step the abow error apeared.(Server: Msg 8966, Level 16, State 1, Line 1Could not read and latch page (1:17688) with latch type SH. sysobjects failed.DBCC execution completed. If DBCC printed error messages, contact your system administrator.) |
|
|
|
hadi354
Starting Member
4 Posts |
Posted - 2012-03-16 : 13:10:18
|
| no any disk image.i have a back up but it is too old. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-16 : 14:16:41
|
quote:
Originally posted by hadi354
exactily sql 2000when I try to query this error apeare:Server: Msg 601, Level 12, State 3, Line 1Could not continue scan with NOLOCK due to data movement.in first my db was suspect.
Yeah, that's a good sign of corrupt DBquote:
i dettach it then my db not attach and appear this error while attaching: "the error 823:I/O error (bad page id)detected during read at offset ..."
That was probably the worst thing you could have done. Never, never, never detach a suspect database.If it hadn't been detached we might have been able to get some data out. Now, probably not.I read an article about the problem and the steps I followed it[url]http://www.sqlserverclub.com/articles/how-to-recover-from-a-corrupted-sql-server-database.aspx[/url]quote:
(Server: Msg 8966, Level 16, State 1, Line 1Could not read and latch page (1:17688) with latch type SH. sysobjects failed.DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Ok, what is the EXACT state of the database? Is it attached to an instance? If so, what are the values for status and status2 in sysdatabases for that DB?Please, do NOTHING else, it's highly unlikely that the DB is recoverable at all anyway.--Gail ShawSQL Server MVP |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-16 : 14:18:29
|
quote:
Originally posted by X002548
Call Microsoft in any case
Probably no point. CSS will tell him to restore from database, to run checkDB and when both of those are not an option, they'll tell him the DB is unrecoverable. They're not allowed to do more than thatquote:
And what about RedGate and Lumigent to recover data from the log? Or is that a no go as well
That'll just be the active portion of the log, and if there's never been a backup or the DB was in simple recovery, that'll be minutes or hours of data changes, nothing more.--Gail ShawSQL Server MVP |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-16 : 14:18:51
|
quote:
Originally posted by hadi354
no any disk image.i have a back up but it is too old.
It's better than nothing.--Gail ShawSQL Server MVP |
|
|
|
|
Db error