In any case, restoring from a backup is the best way to resolve this issue. Or you should try third party SQL repair software as SQLRNNR already suggested. Take a look 'Stellar Phoenix SQL Recovery' Software!!