Question

Locked

It seems our sql database is corrupted

By basrhaidi ·
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?

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

You may try next instrument

by georgeleonard70 In reply to It seems our sql database ...

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/

Collapse -

Take a look at this tool

by MarinaNst In reply to It seems our sql database ...

Try to use dbForge Studio for MySQL. It has a lot of functions and repairing is one of them.

http://www.devart.com/dbforge/mysql/studio/

Collapse -

Recovery-Only Database Restore

by donaldreynolds In reply to It seems our sql database ...

A recovery-only database restore can be useful in the following situations:
You did not recover the database when restoring the last backup in a restore sequence, and you now want to recover the database to bring it online.
The database is in standby mode, and you want to make the database updatable without applying another log backup.
The RESTORE syntax for a recovery-only database restore is as follows:
RESTORE DATABASE database_name WITH RECOVERY
Note Note
The FROM = <backup_device> clause is not used for recovery-only restores because no backup is necessary.
Example
The following example recovers the AdventureWorks2012 sample database in a restore operation without restoring data.
-- Restore database using WITH RECOVERY.
RESTORE DATABASE AdventureWorks2012
WITH RECOVERY

Collapse -

Try to use SQL Database Recovery Tool

by millergibbs In reply to It seems our sql database ...

For an instant solution to repair or recover corrupt SQL Database, you should try to take a help of any professional software like RecoveryFix for SQL Database that very easily repairs badly damaged or corrupt MDF files of SQL Database within few clicks. You can get more details from here http://www.en.repairsqlserver.net/
or
http://www.mdf.repairsqlserver.net

Collapse -

Use Sql Database Recovery Software

by Mistyacole In reply to It seems our sql database ...

Use SQL Database Recovery Tool which can recovers MDF file, NDF File components like triggers, tables, views, rules and stored procedure with ease as well as recovers the deleted tables of the SQL database.The software recovers SQL Server 2012, 2008 / 2008 R2, 2005 and 2000 database files.

Get more information about this software: http://www.recoverydeletedfiles.com/sql-database-recovery-software.html

Collapse -

Try using a better tool

by hanif1992 In reply to It seems our sql database ...

Basrhaidi,

You can try using a better database management tool. I never had to face any such problems while using WinSQL.

http://web.synametrics.com/WinSQL.htm

Collapse -

Easy Steps to Recover SQL Database

by johnwalker5025 In reply to It seems our sql database ...

You can try SQL database recovery tool for instant solution. The software is capable to repair and recover all stored procedure, tables, views, triggers, functions, rules, primary key, unique key and XML data as well from both MDF and LDF file.

For more details: - http://www.repair-sql.net/

Back to Windows Forum
7 total posts (Page 1 of 1)  

Related Forums