Help get this topic noticed by sharing it on Twitter, Facebook, or email.

It seems our sql database is corrupted

Hi,

is there a way to completely check a SQL-Anywhere database (5.5.05)
integrity?

"Validate" won't help: we had databases that were broken but "validate"
always told us that everything is o.k. :-(

I had the idea to simple read every record in every table (first "select
count(*) from...", second "select * from ...") Number of readed records must
be same as the number of records reported by the "count(*)".
- This works ok (i can report errors) - but I have found a database that
will "hang" on the "Count(*)" (seems to loop forever, CPU-Usage 100% for
>20Min (than i stopped it)

Any other ideas?
1 person has
this question
+1
Reply