locked
It seems our sql database is corrupted RRS feed

  • Question

  • 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?
    Monday, July 14, 2014 11:26 AM

Answers