The attached is the result of DBCC CHECKDB and repair_allow_data_loss did not help much. The problem still persists. I have been trying to use some third party tools like kernelsqlrecovery etc which are not helping much. Request you to suggest any script/strategy/tool which would help me in fixing this issue. The backup we have is inconsistent and restoring the backup we have on a different machine ends with the same situation as our production server.
Thanks and Regards