用于分析和恢复SQLServer数据库日志的工具资源-CSDN文库

共129个文件

htm：81个

txt：12个

dll：7个

sql

需积分: 3 73 浏览量 2023-01-14 22:06:28 上传评论收藏 5.44MB ZIP 举报

资源推荐

资源详情

资源评论

收起资源包目录

用于分析和恢复SQLServer数据库日志的工具（129个子文件）

SQLLog.chm 128KB

SvrMgr.chm 14KB

demo.css 1KB

Thumbs.db 28KB

Images.dll 14.4MB

TransView.dll 1.72MB

dbghelp.dll 747KB

LEServer.dll 536KB

LMAlertMsg.dll 52KB

MsgFile.dll 44KB

LMRes.dll 9KB

Setup.exe 4.84MB

LogExplorer.exe 3.27MB

SvrMgr.exe 768KB

Tour.exe 720KB

LES2.exe 668KB

Blat.exe 364KB

LE_rtm.gif 2KB

squareblue.gif 812B

square.gif 807B

ReleaseNotes.htm 47KB

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

Introduction.htm 1KB

FindProblem.htm 1KB

xAnalyze2.htm 1KB

RealTimeMonitorExample.htm 1KB

xViewAndRestore.htm 1KB

CreateSchemaPre.htm 1KB

AuditChanges.htm 1KB

RecoverRepair.htm 1KB

SolveSetup.htm 1KB

RestoreRow.htm 1KB

xIntroduction.htm 1KB

RecoverDroppedTable.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

xRecoverRepair.htm 1KB

xRealTimeMonitorExample.htm 1KB

xPopulateTable.htm 1KB

xDemoOverview.htm 1024B

xApplyAndView.htm 1019B

ApplyUndoTrans.htm 1002B

xAudit.htm 985B

ConnectPre.htm 956B

xFindProblem.htm 951B

RecoverTableTop.htm 935B

xFindProblem2.htm 925B

xRecoverDroppedTable.htm 906B

RealTimeMonitor.htm 901B

Audit.htm 887B

xfaq.htm 886B

xSolveSetup.htm 842B

DropTableDoit.htm 835B

UndoTransaction.htm 833B

Manage.htm 822B

xRealTimeMonitor.htm 818B

xSolve.htm 808B

xSetup.htm 804B

xRunLogExplorer.htm 782B

xUndoTransaction.htm 782B

AnalyzeBehavior.htm 763B

xManage.htm 762B

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

NotFound.htm 589B

xDropTableDoit.htm 573B

xthanks.htm 344B

thanks.htm 342B

xWelcome.htm 338B

共 129 条

Getting Started Guide

Log Explorer

Version 4.1 for Microsoft® SQL Server™ 2000 and 2005

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