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?
