A MSQQL operation of the thrilling experience, restore restore Update operation!

qq|update| Recovery | Data restore

Tonight, in batch processing, remote control Server MSSQL Query Analyzer, may be more impatient hands, in the execution of an update, the mouse only selected the half of the SQL statement when the left hand press the execution of the F5 key (I swear, never dare again.) , the result all of a sudden to all the 4,000-odd software name records all update as [* * * * *], thought finished.

It took a lot of effort to get these materials sorted out, and a F5 was all over.

I thought, is there any way to restore it? The first time to stop the site of IIS, open www.baidu.com, really thank Baidu! Trying to search for keywords: restore SQL update, restore update,SQL Restore update These keywords, finally found two articles of hope, all from csdn, thank csdn!

What is the update in SQL Server (the transaction has been submitted) how can I recover? Http://topic.csdn.net/t/20050117/10/3730983.html

Just a wrong update to the data are all wrong, there is no way to restore, nasty dead!
Http://topic.csdn.net/t/20050117/10/3730983.html

Look inside the introduction, it seems that there is hope for recovery, along the above download address: http://www.yiii.net/app/servlet/net.yiii.club.DownloadServlet?Information_Id=I00023471
Decompression Password www.heibai.net

The software to download, decompression and then installed locally, of course, I want to test in the local can be restored, and then upload to the server restore.
Install, register software .....

Then open their own native MSSQL Query Analyzer, casually to update some things, open Log Explorer software, are all English interface, but according to the csdn of the Netizen introduction method, Step by step:

Registration machine generated is the registration code, with a decompression password to untie, the compression package also has a registration machine.

Open Log Explorer File=>attach log file-> Select server and login mode->connect->
Select Database->attach-> the left dialog box Browse->view log-> can see log records
Want to restore: Right key log record ( I update more than 4,000 records in update, each record produces a log, as long as you randomly select the same group of a right click on the line.) the undo Transation-> chooses to save the file name and path-> and then opens the file to the Query Analyzer to execute T-SQL code.
For example, if log is the delete table where ... , the generated file code is the Insert Table ....

Among them, a netizen said a little request: Your log file is full log.

HOHO, I checked my database log options to change to a simple mode! Heart can be nervous, but through the test, or can be recovered!

Everything has been successfully completed, also gave himself a lesson!

1, pay attention to regular backup.
2, careful operation of the Query Analyzer SQL statements and the mouse.
3. Don't be impatient and dry.

The end of this article:

Reprint please specify the Source: http://www.alixixi.com (Arisisi original)

Finally thanks to Baidu, thank csdn, thank Csdn Chinaandys (18 fried && egg fried rice).