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