SQL Server regret medicine Delete drop update

National Day holiday finally have time to do something because the normal work will do some database operations may have some operational errors refer to

Method one ApexSql of 20,161 software

Http://www.cnblogs.com/gsyifan/p/ApexSql_Log_2016_Crack.html

Method two using the database log backup rollback

Http://www.cnblogs.com/Spacecup/p/4155197.html

This login interface is simple and ssms almost fills in the corresponding can log in after login

Select the appropriate log above the log that is online

Choose this intuitive point

In the future, you can set the time and the relative table settings DML and DDL statements are quite good to use if you just delete the modified data this tool perfectly solves

At this point, congratulations. Delete the change to insert data The regret medicine is already good. Select the data you want to roll back and then right-click to export the script!!! Thank you very much for APEXSQL wing sail!!

But drop table is a bit of a problem and may need to be explored only to restore the table structure without data

Method Two actually is also good is a method of the MS SQL self-brought first to have a full backup of the database this is more important than the other is relatively simple

Back up the thing log and then in the options to back up the log tail with these 2 things basically OK first restore the complete database

Select this do not roll back and then restore the things log

Choose the time period when the wrong operation was done. This operation can theoretically restore all SQL Server operations

All of the above methods have been operated without problems!

Thank you very much for your pioneering great God's trip to thunder!!

Happy National Day!

SQL Server regret medicine Delete drop update