Data Recovery from Log Explorer to drop/truncate table

Bytes ----------------------------------------------------------------------------------------

-- Environment Description:

-- Log Explorer version: Product Ver: 3.1.1, file Ver: 3.0.006 Enterprise Edition

-- DB version: mssql2000 8.00.194

-- Flystone

Http://blog.csdn.net/happyflystone

-- Reprinted to keep this information

Bytes --------------------------------------------------------------------------------------

 

-- Generate Test Database

1. Use master
2. Go
3. Create Database csdn_test
4. Go
5. Use csdn_test
6. Go

 

-- Generate a test table

 

1. Create Table TA (id int)
2. Go
4. Insert into ta select ID from sysobjects
5. Go
6. Select * from Ta
8. /*
10. ID
11. -----------
12. 1
13. 2
14. 3
15. 4
16. 6
17. 8
18. 9
19. 10
20. .......
21. ............
22. 2110682617
23. 2126682674
24. 11199140
25. 27199197
26. 14675150
27. (The number of affected rows is 298)
28. */

 

-- Drop table Ta

 

1. Drop table Ta
2. Go

 

-- Open Log Explorer

 

 

1. Perform the following operations in sequence:
2. Click allach log file on the left.
3. --> Settings: SQL Server, login name, and password
4. --> Click Connect.
5. --> Select the database and use on-line log
6. --> Click attach and confirm again.
7. --> Click salvage dropped/truncated data on the left.
8. --> Input table: DBO. Ta
9. Enter approximate time the table was dropped/truncated:
10. 16:00:00 (modified here)
11. Condition: Select Table was droped
12. --> CLICK: Create
14. Log Explorer automatically creates a text file with the following content:
17. Create Table [DBO]. [Ta] ([ID] INT)
18. Insert into [DBO]. [Ta] ([ID]) values (1)
19. Insert into [DBO]. [Ta] ([ID]) values (2)
20. Insert into [DBO]. [Ta] ([ID]) values (3)
21. Insert into [DBO]. [Ta] ([ID]) values (4)
22. Insert into [DBO]. [Ta] ([ID]) values (6)
23. Insert into [DBO]. [Ta] ([ID]) values (8)
24. Insert into [DBO]. [Ta] ([ID]) values (9)
25. Insert into [DBO]. [Ta] ([ID]) values (10)
26. Insert into [DBO]. [Ta] ([ID]) values (11)
27. Insert into [DBO]. [Ta] ([ID]) values (12)
28. Insert into [DBO]. [Ta] ([ID]) values (14)
29. Insert into [DBO]. [Ta] ([ID]) values (19)
30. Insert into [DBO]. [Ta] ([ID]) values (20)
31. Insert into [DBO]. [Ta] ([ID]) values (21)
32. .....
33. .......
34. Insert into [DBO]. [Ta] ([ID]) valuees (1326679824)
35. Insert into [DBO]. [Ta] ([ID]) valuees (1486680394)
36. Insert into [DBO]. [Ta] ([ID]) valuees (1518680508)
37. Insert into [DBO]. [Ta] ([ID]) valuees (2096166663)
38. Insert into [DBO]. [Ta] ([ID]) valuees (1330871858)
39. Insert into [DBO]. [Ta] ([ID]) valuees (1416496225)
40. Insert into [DBO]. [Ta] ([ID]) valuees (1420740314)
41. Insert into [DBO]. [Ta] ([ID]) valuees (1553440608)
42. Insert into [DBO]. [Ta] ([ID]) valuees (214044294)
43. Insert into [DBO]. [Ta] ([ID]) valuees (1855970334)
44. Insert into [DBO]. [Ta] ([ID]) valuees (1887970448)
45. Insert into [DBO]. [Ta] ([ID]) valuees (1903970505)
46. Insert into [DBO]. [Ta] ([ID]) valuees (1993058136)
47. Insert into [DBO]. [Ta] ([ID]) valuees (2009058193)
48. Insert into [DBO]. [Ta] ([ID]) valuees (1998890438)
49. Insert into [DBO]. [Ta] ([ID]) valuees (2110682617)
50. Insert into [DBO]. [Ta] ([ID]) valuees (2126682674)
51. Insert into [DBO]. [Ta] ([ID]) valuees (11199140)
52. Insert into [DBO]. [Ta] ([ID]) valuees (27199197)
53. Insert into [DBO]. [Ta] ([ID]) valuees (14675150)

 

-- Test successful

-- Note: The above data is local test data, and the intermediate data is omitted.