恢复被delete/update的数据资源-CSDN文库

共135个文件

htm：81个

txt：16个

jpg：7个

需积分: 9 14 浏览量 2009-12-14 23:40:51 上传评论收藏 3.26MB RAR 举报

操作步骤 1　连接到被删除数据库的Db 打开log explorer 选择 "file "-> "attach log file "-> 选择服务器和登陆方式-> "connect "-> 选择 "数据库 "-> "attach " 2 查看日志在左面操作项目的对话框中选择 "browse "项目-> "view log "-> 就可以看到当前的Log记录了 3 恢复数据右键某一条log记录,选择 "undo transation "-> "选择保存文件名和路径 "-> 然后打开该文件到查询分析器里执行 T-sql代码就可以了例如: 如果log是delete table where ...的话,生成的文件代码就是insert table .... 二如何恢复被drop table和truncate table后的数据 1 连接到被删除数据库的Db 操作同上 2 恢复方法 1) 选择 "salvaage dropped/truncate "菜单,在右边的对话框中选择表名,和droped/trucated的日期, File Name中选择生成insert语句脚步的存放位置,condition选择是droped还是truncated, 最后点击 "create " 就会生成insert语句,把生成的语句到查询分析器里面执行一下就可以了 2) 选择 "ViewDDL Commands "菜单-> 选 "truncate table " 操作项-> 点击 "Salvage "-> 生成语句-> 查询分析器里执行三 log explorer使用的几个问题 1) 对数据库做完全/差异/日志备份备份时如果选用了删除事务日志中不活动的条目再用Log explorer打试图看日志时,提示No log recorders found that match the filter，would you like to view unfiltered data 选择yes 就看不到刚才的记录了如果不选用了删除事务日志中不活动的条目再用Log explorer打试图看日志时，就能看到原来的日志并做恢复 2) 修改了其中一个表中的部分数据，此时用Log explorer看日志，可以作日志恢复 3) 然后恢复备份，(注意:恢复是断开log explorer与数据库的连接，或连接到其他数据上，否则会出现数据库正在使用无法恢复) 恢复完后，再打开log explorer 提示No log recorders found that match the filter，would you like to view unfiltered data,选择yes 就看不到刚才在2中修改的日志记录，所以无法做恢复. 4) 不要用SQL的备份功能备份,搞不好你的日志就破坏了. 正确的备份方法是: 停止SQL服务,复制数据文件及日志文件进行文件备份. 然后启动SQL服务,用log explorer恢复数据

资源推荐

资源详情

资源评论

收起资源包目录

恢复被delete/update的数据（135个子文件）

SQLLog.chm 114KB

SvrMgr.chm 14KB

demo.css 1KB

Images.dll 3.55MB

TransView.dll 900KB

dbghelp.dll 747KB

LEServer.dll 564KB

LMAlertMsg.dll 52KB

MsgFile.dll 44KB

LogExplorer.exe 3.26MB

setup.exe 2.88MB

Tour.exe 720KB

LES2.exe 432KB

SvrMgr.exe 160KB

Blat.exe 115KB

LE_rtm.gif 2KB

squareblue.gif 812B

square.gif 807B

ReleaseNotes.htm 18KB

AuditSchema.htm 9KB

RunLogExplorer.htm 3KB

Helpfile.htm 3KB

faq.htm 3KB

ViewAndRestore.htm 2KB

wrapup.htm 2KB

FindProblem2.htm 2KB

Cleanup.htm 2KB

xwrapup.htm 2KB

DemoOverview.htm 2KB

Analyze2.htm 2KB

AuditUsers.htm 2KB

xCleanup.htm 2KB

UndoTransLE.htm 1KB

AuditExport.htm 1KB

FindProblem.htm 1KB

xAnalyze2.htm 1KB

RealTimeMonitorExample.htm 1KB

xViewAndRestore.htm 1KB

Introduction.htm 1KB

CreateSchemaPre.htm 1KB

AuditChanges.htm 1KB

RecoverRepair.htm 1KB

SolveSetup.htm 1KB

RestoreRow.htm 1KB

xIntroduction.htm 1KB

xauditschema.htm 1KB

NoLogExplorer.htm 1KB

ApplyAndView.htm 1KB

xUndoTransLE.htm 1KB

Solve.htm 1KB

xAuditChanges.htm 1KB

xRestoreRow.htm 1KB

PopulateTable.htm 1KB

xAuditExport.htm 1KB

xAuditUsers.htm 1KB

Setup.htm 1KB

ComplexTrans.htm 1KB

RecoverDroppedTable.htm 1KB

xRecoverRepair.htm 1KB

xRealTimeMonitorExample.htm 1KB

xPopulateTable.htm 1KB

xDemoOverview.htm 1024B

xApplyAndView.htm 1019B

ApplyUndoTrans.htm 1002B

xAudit.htm 985B

ConnectPre.htm 955B

xFindProblem.htm 951B

xFindProblem2.htm 925B

xRecoverDroppedTable.htm 906B

RealTimeMonitor.htm 901B

Audit.htm 887B

xfaq.htm 886B

xSolveSetup.htm 842B

UndoTransaction.htm 833B

Manage.htm 822B

xRealTimeMonitor.htm 818B

xSolve.htm 808B

xSetup.htm 803B

xUndoTransaction.htm 782B

xRunLogExplorer.htm 782B

AnalyzeBehavior.htm 763B

xManage.htm 762B

RecoverTableTop.htm 760B

xCreateSchemaPre.htm 744B

xComplexTrans.htm 743B

PopulateTablePost.htm 728B

xAnalyzeBehavior.htm 704B

xApplyUndoTrans.htm 701B

xPopulateTablePost.htm 693B

xNoLogExplorer.htm 681B

xConnectPre.htm 672B

xRecoverTableTop.htm 664B

DropTableDoit.htm 660B

NotFound.htm 589B

xDropTableDoit.htm 573B

xthanks.htm 344B

thanks.htm 342B

xWelcome.htm 338B

Welcome.htm 335B

checked.ico 318B

共 135 条

Getting Started Guide

Log Explorer

Version 4.0 for Microsoft® SQL Server™ 7.0 and 2000

THIS DOCUMENT AND THE SOFTWARE DESCRIBED IN THIS DOCUMENT ARE FURNISHED UNDER AND ARE

SUBJECT TO THE TERMS OF A LICENSE AGREEMENT OR A NON

-DISCLOSURE AGREEMENT. EXCEPT AS

EXPRESSLY SET FORTH IN SUCH LICENSE AGREEMENT OR NON

-DISCLOSURE AGREEMENT, LUMIGENT

TECHNOLOGIES, INC. PROVIDES THIS DOCUMENT AND THE SOFTWARE DESCRIBED IN THIS

DOCUMENT

“AS IS” WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT

NOT LIMITED TO

, THE IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR

PURPOSE

. SOME STATES DO NOT ALLOW DISCLAIMERS OF EXPRESS OR IMPLIED WARRANTIES IN CERTAIN

TRANSACTIONS

; THEREFORE, THIS STATEMENT MAY NOT APPLY TO YOU.

This document and the software described in this document may not be lent, sold, or given away without

the prior written permission of Lumigent Technologies, Inc., except as otherwise permitted by law. Except

as expressly set forth in such license agreement or non-disclosure agreement, no part of this document or

the software described in this document may be reproduced, stored in a retrieval system, or transmitted in

any form or by any means, electronic, mechanical, or otherwise, without the prior written consent of

Lumigent Technologies, Inc. Some companies, names, and data in this document are used for illustration

purposes and may not represent real companies, individuals, or data.

This document could include technical inaccuracies or typographical errors. Changes are periodically made

to the information herein. These changes may be incorporated in new editions of this document. Lumigent

Technologies, Inc. may make improvements in or changes to the software described in this document at

any time.

U.S. Government Restricted Rights: The software and the documentation are commercial computer

software and documentation developed at private expense. Use, duplication, or disclosure by the

Government is subject to the terms of the Lumigent standard commercial license for the software, and

where applicable, the restrictions set forth in the Rights in Technical Data and Computer Software clauses

and any successor rules or regulations.

Lumigent, Log Explorer, and the Lumigent logo are trademarks or registered trademarks of Lumigent

Technologies, Inc. All other names and trademarks are property of their respective owners and are

protected by the laws of the United States and other countries. Log Explorer uses technology that is the

subject of one or more U.S. patent applications of Lumigent Technologies, Inc.

Contents iii

Contents

About This Book.......................................................................................................................................... v

Conventions................................................................................................................................................. vi

Contacting Lumigent .................................................................................................................................vii

Chapter 1

Log Explorer Introduction 1

What Is Log Explorer?................................................................................................................................ 1

What Does Log Explorer Provide?........................................................................................................... 2

Transaction Log Browsing...........................................................................................................2

Selective Data Recovery...............................................................................................................3

Data Export....................................................................................................................................3

Why Use Log Explorer?.............................................................................................................................. 4

How Does Log Explorer Work?................................................................................................................4

Chapter 2

Installation 5

Components and Requirements.................................................................................................................5

Before You Start........................................................................................................................................... 6

Licensing......................................................................................................................................... 6

Installing Log Explorer on a Cluster.......................................................................................... 7

Client Installation .........................................................................................................................................8

Single Server Installation...........................................................................................................................10

Multiple Server Installation.......................................................................................................................12

Enabling and Disabling the Capture of Session Login Information .................................................14

Chapter 3

Getting Started 17

Connecting to Your Database..................................................................................................................19

iv Getting Started Guide

Attaching in a Cluster Environment.........................................................................................20

Attaching through TCP ..............................................................................................................20

Log Explorer Functions.............................................................................................................................21

Exploring the Log.......................................................................................................................................24

Browsing........................................................................................................................................24

Filtering..........................................................................................................................................31

Real-Time Monitor......................................................................................................................33

Row Revision History.................................................................................................................34

Row Transaction History............................................................................................................35

View DDL Commands...............................................................................................................36

Exporting Data............................................................................................................................................37

Export to SQL Server Table......................................................................................................37

Export to File...............................................................................................................................39

Recovering Data..........................................................................................................................................41

Undo User Transactions.............................................................................................................41

Redo User Transactions..............................................................................................................43

Salvaging Data..............................................................................................................................44

Recovery Tasks.............................................................................................................................48

Rollback a Table...........................................................................................................................48

Rollback a Row.............................................................................................................................49

Undelete (Restore) Deleted Rows.............................................................................................50

Undo a Transaction in the Browse Log View.........................................................................50

Undo an Operation in the Browse Log View .........................................................................51

Running a SQL Script ................................................................................................................................51