It seems our SQL database is corrupted

Tags:
Backup and Recovery
SQL Database
SQL Server
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
1

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/

Know simple approach: SQL Database Recovery

Discuss This Question: 2  Replies

 
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.
  • Subhendu Sen
    Database reloading/uploading might be helpful. How did you check? Did you run DBCC CheckDB? If yes, what is the result? keep in mind, support of this version stops since 2002 ends.
    132,270 pointsBadges:
    report
  • ToddN2000
    If you do not know the reason for the database failing you might want to take a look at the server to see if you are having hardware issues like a drive possibly going bad.
    127,470 pointsBadges:
    report

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.

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

Following

Share this item with your network: