How to restore deleted data using the delete statement

Category: MS-SQL Server -> Applications Author: vip6700 Date: 2001-07-09 03:53:05
 
vip6700
2001-07-09 03:53:05
sqlserver2000
I used in Query Analyzer 400 Delete to delete the data you heroes there any way I can restore it
kabaxiaozi
2001-07-09 04:09:52
using third-party tools

Log Explorer 3.2

extract passwords www.heibai.net

Log Explorer for SQL Server v4.0.2

RI registration code is generated, is two

password used to unlock after decompression, compression bag also has an RI

open log explorer ; file => attach log file-> Select Server and landing approach -> connect->
Select Database -> attach-> left dialog box, browse-> view log- > you can see the log records
want to restore it: Right-log record undo transation-> select to save the file name and path -> then open the file to the Query Analyzer execution
T-sql code on

example, if the log is delete table where ..., then the generated file code is insert table ....

--------------------------------------------- ---------------------------

log explorer using several problems

1) differences in the database do a full backup and log backup
chosen to delete inactive transaction log entries
then Log explorer fight trying to see logs
Tip No log recorders found that match the filter, would you like to view unfiltered data
select yes do not see just recorded

If you do not choose to delete inactive transaction log entries
then Log explorer play when trying to look at the log, you can see the original log

2) modify them a part of the data in the table, this time with Log explorer look at the log, can be used for log recovery

3) and then restore the backup (Note: The recovery is to disconnect the connection to the database log explorer, or Connecting to other data,
otherwise there will not be restored database is in use)
restore exhausted, and then open the log explorer prompted No log recorders found that match the filter, would you like to view unfiltered data
choose yes will not see mentioned in the two modified logging, so I can not make restitution.

3)
Do not use the SQL backup features, they might destroy your log on.

correct backup method:
stop the SQL service, copy the data files and log files for file backup.

then start SQL services, using log explorer recover data

fishman0071
2001-07-09 04:46:49
There is no log file, log file if there is, it should be with log explorer.
wyy026
2001-07-09 05:03:59
have a database log files
yulove123
2001-07-09 05:34:22
I installed was an error: failed find sql server in the fllowing path \ server \ binn error
I do not find the network name
installed on the database server, I have a workstation installation okay?
xuwenjieya
2001-07-09 06:11:11
to: zjcxc (Zou) Help ah! ! ! !
cao0441
2001-07-09 06:37:20
to be installed on the database server job.
adu1217
2001-07-09 06:59:00
Thank you! ! ! ! !
Retrieving data!!!!!!!!!
xo8080
2001-07-09 07:32:06
Done!!!!!!
thank the boss 100 points give you all!!!!!!!!! !!!!!