HDD GURU FORUMS

Hi to all,

I have copy a disk with some SQL databases and could copy about 98% off the sectors for the database.
But is missing 2% off that sectors, anyone experience in SQL server know the command line to repair the database?

Please PM me


Thanks
ZeBong

Hi,

It depends on sql type, but for mysql the procedure looks like this:
USE [database]
REPAIR TABLE [table]

If it is failing, try outside of the server with myisamchk.

http://dev.mysql.com/doc/refman/5.0/en/ ... table.html

Always make a backup before trying to repair the table!

Janos