Today accidentally performed a wrong operation on the database, thinking that there is no tool to restore this error operation? The log Explorer 4.2 was found, but it only supported SQL 2005, was not available on SQL 2008, and then found the ApexSQL log, with the most recent version supporting SQL 2008 and SQL 2012, The trial version can provide unlimited 14-day free trial, the function is really powerful
Direct download installation, official download address: http://www.apexsql.com/sql_tools_log.aspx
Installation complete, open the main interface:
Click "New":
Enter database related information and then click Open:
Click "Evaluate Product":
The table lists the actions that were performed before, and the right mouse button on the wrong line will show many menus, and create Undo script is a restore:
After this script is generated, the error can be recovered by performing: