Thank you all again.
As for the transactions, it is more of an old data import rather than live transaction.
Problem is when we imported those old transaction date, it took good 300 hours. By the way, this incident happened on Wednesday 7 pm and if our oldest log file's time stamp is Wednesday 10pm, is this mean we have to start entering these information again??
Our Navision consultant thinks it's safer to restore data from Navision rather than SQL Server and I absoultely have no idea what he's talking. Currently he is asking me to extract deleted data from
the log file, generate csv file, then give him that data so he can enter it back into Navision. :ermm:
Now I tried ApexSQL Log and SQL Log Rescure, and looks like these might do the job. But I couldn't just get the raw data. It created TSQL commands. Another thing I found is that if the column is updated, looks like I won't be able to get data back with these tools.
Anyway thank you again for your help 🙂