Scppo:sql How to recover the error operation?

Source: Internet
Author: User
Tags sql error

"Preface"

Today's research project's own confused content should be the core of the system-data from the uploaded access to parse out (ETL contribution) through a series of stored procedures to put the data into the database table (every morning will be timed to perform this series of operations) this is just today's primer, Not specific in-depth explanation, the small series will be in the next blog post more in-depth for everyone to share;

In the analysis of this piece of time inadvertently found on the server a software-apexsql Log; did not contact before out of curiosity on the Internet to check what it is to use, this check does not matter, and ignited their new interest, as if all the heaven in its own arrangements! Why do you say that? Small series below for everyone to explain.

"The Journey of Discovery"

Believe that a bit of development experience of friends are aware of the power of SQL statements, a sentence of SQL can change the whole world ha! Still remember before the world super and Hao elder brother have told a SQL error operation caused by the effect (such as: Delete, Update when forget the Where condition, etc.), often occurs in the official library, after execution: Mom! The heart that wants to be reborn again has! Believe that some readers have experienced, understand the power of the small part in the direct operation of SQL is doubly careful, check again and again, even if it is sometimes difficult to escape the clutches of the hand owed!

has been struggling to find a magic can drink regret medicine like, make up for the loss; I bumped into it today!

application Scenario:SQL Error Operation!

Scenario Reproduction:

• Create a table in the local database and write some data for testing purposes (in this case, test is the database with Testsql as the table).


• Analog Misoperation (in this case delete the entire table as an example)


Use process:

Installation: Download the installation package for installation (: Http://pan.baidu.com/s/1qYoygMS), the installation process and common software is exactly the same here no longer repeat.

• Use the software (in this case, the 2013 cracked version for example) for data recovery:

1. Fill in the relevant information of the connection database:


2. Select an evaluation version


3.ApexSQL creates a log library:


4. Select the recovery time as appropriate:


5. Open the Log Action table:


6. View the operation log for the database:


7. Perform a recovery operation (to recover the first deleted data as an example, if you want to recover the entire deletion of 11 data simply repeat the Step):


8. View the recovered script:


9. Execute the recovery script in SQL Server:


• Verify after Recovery:


Warm tips:

official website (http://www.apexsql.com/sql_tools_ log.aspx) has been out to 2016 version, in the use of the 2016 version of the process did not find the cracked version, resulting in a limited recovery operation, or the above example, in the view of the recovery log when the following occurs (we recommend that you use the cracked version of 2013 feature complete):

"Summary"

1. solemnly declare: Through the system input data, strict process will fundamentally avoid the emergence of this situation; But the reality is that a lot of development is not strictly in accordance with the norms, such a situation is often happening (you and I understand)!

2. Keep a curious heart on new things, and learn more about things you haven't touched!

3. It is only a remedial measure to be cautious when operating the database (especially on the online database), and not to make a mistake about the database because of it.

Scppo:sql How to recover the error operation?

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.