What is the most tragic thing about the world for programmers? -The hand is cheap, the data of the database to delete, more sad is the wood has any database backup
This happened today, a colleague delete data table data is not written conditions, the result oo, the table data is all gone.
after a morning struggle finally to restore the data, thanks to the almighty degree Niang, thanks to the selfless dedication of netizens, most grateful for the powerful Logexplorer tools. Fortunately, it is not me today to get rid of the data, or I must be in a hurry, not so calm to find a solution.
Using the LogExplorer4.2 tool
1) First download the installation package, you can download it below
Http://www.pc6.com/softview/SoftView_57657.html
Installation procedures refer to the 2nd) point inside the file, install the package is attached, after the installation of the Chinese package (do not know when the path is not the same as the installation path before the Han, anyway, I was the time to overwrite the original before the path of Han)
2) Logexplorer4.2+for+sql+server Use the tutorial, as follows, there are 2 kinds of data deletion recovery operations: one) to recover deleted data from a data table (delete from TableName), and second) to restore the deleted table (drop Table TableName)
Http://wenku.baidu.com/link?url= qt4gpodvv4czna1uglvhjtak8hjdv5a6kxbkqpdqnwd2hjsq0qvswxvz-usumm7ifcoqgfeaypdtfar4xixhikh8_rknds-rsflqscm5o6m
You can also download the above documentation below for free points:
http://download.csdn.net/detail/hellocjr/8108615
Reference: http://blog.163.com/tech_memo/blog/static/6443684220092177251246/
http://blog.163.com/[email protected]/blog/static/132373046201052841232492/
SQL database recovery artifact--log Explorer 4.2 using tutorial