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.
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/
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
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
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.
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.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
It seems our sql database is corrupted
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?