SQL Server regret medicine Delete drop update

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.