Question Status

Suggested Answer
maram fraij asked a question on 26 Mar 2014 10:10 AM

We changed the data type from sting to memo which causes a data corruption so the Arabic characters appear as question marks (??????).

How can we retrieve the original data in select statement with original contents before  corruption note that we do not have a DB backup.

We try Select convert(nchar,text) and we got nothing

Reply
Suggested Answer
Denis Macchinetti responded on 26 Mar 2014 11:53 AM

Hi Maram

If your AX Database "Recovery Models" option is set to "Bulk logged" or "Full" I think you can retrieve the data from the ldf files.

Try to have a look at www.wikihow.com/Analyze-SQL-Server-Log-Transaction-(LDF-File)-and-Recover-Corrupt-SQL-Data-with-SysTools-SQL-Log-Analyzer

Thanks & Regards

Denis Macchinetti

Senior Technical Architect

Reply
Suggested Answer
Denis Macchinetti responded on 26 Mar 2014 11:53 AM

Hi Maram

If your AX Database "Recovery Models" option is set to "Bulk logged" or "Full" I think you can retrieve the data from the ldf files.

Try to have a look at www.wikihow.com/Analyze-SQL-Server-Log-Transaction-(LDF-File)-and-Recover-Corrupt-SQL-Data-with-SysTools-SQL-Log-Analyzer

Thanks & Regards

Denis Macchinetti

Senior Technical Architect

Reply