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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!