Original: ApexSQL log-sql Error-Operation recovery Tool
Today accidentally performed a mis-operation of the database, wondering if there is any tool to recover this error operation? The log Explorer 4.2 was found, but unfortunately it only supported SQL 2005, could not be used on SQL 2008, and then found ApexSQL log, with the latest version supporting SQL 2008 and SQL 2012. The trial version offers a free 14-day trial with unlimited functionality.
Direct download installation, official: http://www.apexsql.com/sql_tools_log.aspx
When the installation is complete, open the main interface:
Click "New":
Enter information about the database and click "Open":
Click on "Evaluate Product":
The table lists the previous actions, and the right mouse button on the wrong line will cause a lot of menus, and "Create Undo script" is the one that creates the recovery scripts:
After this script is generated, it can be resumed by mistake:
ApexSQL log-sql Error-operated recovery tool