Retrieve lost data with SQL logs

xiaoxiao2021-04-02  253

In the past few days, I met my life in my life. When I was Update on a list of data in a table, I took a WHERE statement, which caused all of the entire data, which is all lost, and before Back up the subaracted database, and hurry to find the tool.

Found 3:

Log Explorer

Apex SQL LOG SQL LOG RESCUE

First of all, I said the first Log Explorer, the first possible many people have been used, I downloaded the database, point the view log, I found a lot of operational records, but no matter how to adjust, the log is June From 12th to June 16, I don't know why my database log is only starting from June 12, please explain it. For the words, I carefully read the records of the operations. There are many changes that have changed, but the columns I change is Ntext type. The data cannot be seen, you can't find my NTEXT type data using undo and redo, even Use "Export Log Records" and "Recovery" operations that cannot be found. NTEXT data. I have to find the second one with a very sadness.

The second Apex SQL log, and the log expenditure, the NTEXT data is not found in the log record, and later use "Recovery Wizard" to select recovery data, the NTEXT field I have modified in SQL is all 0x000 . . . Such binary data, the original NTEXT type storage and other data types are stored in different ways, and NTEXT stores in the database is just a pointer to NText content, I tried to read it with readtext, which gives me a pointer, but I can't read it. When I go to www.apexsql.com/, I will go to consult. It turns out that this software has a bug in this place. When the NTEXT type is restored, only a pointer is wrong. They can't restore it, they say in the next version. Only solve this problem, no way.

The third SQL Log Rescue, this really makes me excited, because when I connect to the database read the log, I found some of the NTEXT types of NTEXT types before the change have changed the value after the change, he is on the recorded record It also compares the value of these two NText types, but happy, I found out that I only found a few such values, I came to the official homepage. I realized that he value is because of my UPDATE. Record in the previous log, but my log is only from June 12 to June 16th, and I don't know why I haven't, so I can only find a few records. .

Summary: Individual thinks that Log Explorer makes me a little gain this time, Apex SQL logs at least let me know where I have modified NTEXT type storage, I look forward to seeing him to find, SQL log rescue let me recover several data, Unfortunately, if the log is completely recovered, I hope the master will explain it.

转载请注明原文地址:https://www.9cbs.com/read-131399.html

New Post(0)