Retrieve files from mySQL server 2000 Database after being corrupt

Asked By 0 points N/A Posted on -
qa-featured

Hi,

Is there any possible way to retrieve .mdf files from mySQL server 2000 Database after it went corrupt due to virus infection? Are there any software available to recover missing files?

Thanks,

Ren

SHARE
Best Answer by Williams Todd
Best Answer
Best Answer
Answered By 0 points N/A #170043

Retrieve files from mySQL server 2000 Database after being corrupt

qa-featured

Hello,

To resolve this issue, you need to perform some repair operations on the tables of your database. For that, use  — recover, the –quick option and % myisamchk. The latter is very useful in repairing the tables without touching the data file. There are other slow options to use such as –safe-recover but few errors could be fixed. To remove temporary files completely –force option should be used. Check SQLRep.txt file attached to this message for instructions.

Another solution is to download MySQLRecovery. It is a data recovery software for damaged MySQL Server.

I hope this is helpful.

Answered By 0 points N/A #170045

Retrieve files from mySQL server 2000 Database after being corrupt

qa-featured

Hello Ren,

First of all backup your database files (.mdf & .ndf).

Are you able to attach the database? If not the share the error message.

If you will be able to attach the database then run DBCC CHECK on the database. If you will find error messages the re-run DBCC CHECKDB with repair_allow_data_loss.

Note: Data will be lost.

There are some good SQL server 2000 database recovery software available on the Internet. Download the demo version of the software and repair the corrupt file. You may pay some amount for it. 

Login/Register to Answer

Related Questions