It seems our SQL database is corrupted

5 pts.
Tags:
Backup and Recovery database
Microsoft SQL Server
SQL Database
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?

Software/Hardware used:
Microsoft SQL Server

Answer Wiki

Thanks. We'll let you know when a new response is added.
Backup your table (just copy your table files to somewhere else). Than execute “repair table yourtablename”. Mostly table corruptions are on index files and easyly recoverable. Unexpected shutdowns or disk space problems may have results like this.
In case first proposition didn’t help you. Use repair & restore your corrupt MySQL database by MDF Repair Kit

It is read only in nature and successful restore table corruption in MySQL database. You can download free demo version to see the preview of your corrupt database http://www.mdf.repair/

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following