Recovery of SQL Server 2000 erroneous deletion data _mssql

Today accidentally the client side of the database deleted more than 1000 data, and before there is no backup, really is very depressed, and later found a tool on the internet, used up quite convenient, let me avoid a robbery.
First look at the interface:

Enter the server address, username and password after point Connect, enter the following interface:

Select the database where you want to restore the data, choose Use on-line Log (if you back up the file, you will not need to use this tool, directly with SQL). Then click Attach to enter the following interface:

You can see that there are a lot of features in the left menu, we want to restore the data, first of all to see the log, to find out that we mistakenly operate those log records, point browse view log:

So that we can see all the log of operations for this database, we can filter out what we need according to the date and other conditions:

After you filter the log, it's time to export the data, the tool provides two ways, the first is to export into an XML or HTML file (corresponding to the export to file in the left menu), the second is to build a new table directly in the database, and then import the data (export to SQL).
Let's take a look at the import to SQL, first point the Export to SQL option:

Enter the name of the database and table, and finish.
This allows you to see a few tables in your data database:
TestTable
Testtable_dll
Testtable_details
Testtable_keys
Testtable_login

The recovered data is in the Testtable_details table, but the data format has changed, and you need to write the stored procedure or import it into the original table in other ways.

All the above to share is to restore the SQL Server 2000 mistakenly delete the data solution, everyone in the process of learning may accidentally accidentally deleted the database data, with a small series to provide the method, hoping to help everyone.