首页 Log Explorer

Log Explorer

上传者： kuku19831980 | 上传时间： 2024-07-05 17:24:15 | 文件大小： 3.29MB | 文件类型： RAR
SQL code使用Log Explorer查看和恢复数据 Log Explorer 4.1.可用于SQL Server2005的日志查看工具 下载地址: http://download.csdn.net/source/620271 使用方法: 打开Log Explorer -> Attach Log File -> 选择SQL Server服务器和登陆方式 -> Connect -> 在Database Name中选择数据库 -> Attach-> 左面对话框中Browse-> View Log-> 就可以看到log记录了 想恢复的话: 右键Log记录 Undo Transation-> 选择保存文件名和路径-> 然后打开该文件到查询分析器里执行 T-sql代码就可以了 例如 如果Log是delete table where ...的话,生成的文件代码就是insert table .... 然后将此insert table的代码放到查询分析器里执行.就可以恢复数据. ---------------------------------------------------------------------- --如何恢复被delete/update的数据 ---------------------------------------------------------------------- 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 .... ---------------------------------------------------------------------- --Log Explorer恢复被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"->生成语句->查询分析器里执行

文件下载

资源详情

[{"title":"（ 131 个子文件 3.29MB ） Log Explorer","children":[{"title":"SQLLog.chm <span style='color:#111;'> 113.58KB </span>","children":null,"spread":false},{"title":"SvrMgr.chm <span style='color:#111;'> 14.36KB </span>","children":null,"spread":false},{"title":"demo.css <span style='color:#111;'> 1.03KB </span>","children":null,"spread":false},{"title":"Images.dll <span style='color:#111;'> 3.55MB </span>","children":null,"spread":false},{"title":"TransView.dll <span style='color:#111;'> 900.07KB </span>","children":null,"spread":false},{"title":"dbghelp.dll <span style='color:#111;'> 747.00KB </span>","children":null,"spread":false},{"title":"LEServer.dll <span style='color:#111;'> 563.64KB </span>","children":null,"spread":false},{"title":"LMAlertMsg.dll <span style='color:#111;'> 52.00KB </span>","children":null,"spread":false},{"title":"MsgFile.dll <span style='color:#111;'> 44.00KB </span>","children":null,"spread":false},{"title":"LogExplorer.exe <span style='color:#111;'> 3.26MB </span>","children":null,"spread":false},{"title":"setup.exe <span style='color:#111;'> 2.88MB </span>","children":null,"spread":false},{"title":"Tour.exe <span style='color:#111;'> 720.00KB </span>","children":null,"spread":false},{"title":"LES2.exe <span style='color:#111;'> 432.07KB </span>","children":null,"spread":false},{"title":"SvrMgr.exe <span style='color:#111;'> 160.08KB </span>","children":null,"spread":false},{"title":"Blat.exe <span style='color:#111;'> 114.50KB </span>","children":null,"spread":false},{"title":"keygen.exe <span style='color:#111;'> 53.69KB </span>","children":null,"spread":false},{"title":"LE_rtm.gif <span style='color:#111;'> 1.56KB </span>","children":null,"spread":false},{"title":"squareblue.gif <span style='color:#111;'> 812B </span>","children":null,"spread":false},{"title":"square.gif <span style='color:#111;'> 807B </span>","children":null,"spread":false},{"title":"ReleaseNotes.htm <span style='color:#111;'> 18.42KB </span>","children":null,"spread":false},{"title":"AuditSchema.htm <span style='color:#111;'> 8.70KB </span>","children":null,"spread":false},{"title":"RunLogExplorer.htm <span style='color:#111;'> 3.24KB </span>","children":null,"spread":false},{"title":"Helpfile.htm <span style='color:#111;'> 3.18KB </span>","children":null,"spread":false},{"title":"faq.htm <span style='color:#111;'> 2.86KB </span>","children":null,"spread":false},{"title":"ViewAndRestore.htm <span style='color:#111;'> 1.97KB </span>","children":null,"spread":false},{"title":"wrapup.htm <span style='color:#111;'> 1.90KB </span>","children":null,"spread":false},{"title":"FindProblem2.htm <span style='color:#111;'> 1.84KB </span>","children":null,"spread":false},{"title":"Cleanup.htm <span style='color:#111;'> 1.82KB </span>","children":null,"spread":false},{"title":"xwrapup.htm <span style='color:#111;'> 1.77KB </span>","children":null,"spread":false},{"title":"DemoOverview.htm <span style='color:#111;'> 1.74KB </span>","children":null,"spread":false},{"title":"Analyze2.htm <span style='color:#111;'> 1.72KB </span>","children":null,"spread":false},{"title":"AuditUsers.htm <span style='color:#111;'> 1.60KB </span>","children":null,"spread":false},{"title":"xCleanup.htm <span style='color:#111;'> 1.53KB </span>","children":null,"spread":false},{"title":"UndoTransLE.htm <span style='color:#111;'> 1.50KB </span>","children":null,"spread":false},{"title":"AuditExport.htm <span style='color:#111;'> 1.47KB </span>","children":null,"spread":false},{"title":"FindProblem.htm <span style='color:#111;'> 1.46KB </span>","children":null,"spread":false},{"title":"xAnalyze2.htm <span style='color:#111;'> 1.44KB </span>","children":null,"spread":false},{"title":"RealTimeMonitorExample.htm <span style='color:#111;'> 1.44KB </span>","children":null,"spread":false},{"title":"xViewAndRestore.htm <span style='color:#111;'> 1.40KB </span>","children":null,"spread":false},{"title":"Introduction.htm <span style='color:#111;'> 1.40KB </span>","children":null,"spread":false},{"title":"CreateSchemaPre.htm <span style='color:#111;'> 1.40KB </span>","children":null,"spread":false},{"title":"AuditChanges.htm <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"RecoverRepair.htm <span style='color:#111;'> 1.33KB </span>","children":null,"spread":false},{"title":"SolveSetup.htm <span style='color:#111;'> 1.33KB </span>","children":null,"spread":false},{"title":"RestoreRow.htm <span style='color:#111;'> 1.28KB </span>","children":null,"spread":false},{"title":"xIntroduction.htm <span style='color:#111;'> 1.26KB </span>","children":null,"spread":false},{"title":"xauditschema.htm <span style='color:#111;'> 1.21KB </span>","children":null,"spread":false},{"title":"NoLogExplorer.htm <span style='color:#111;'> 1.19KB </span>","children":null,"spread":false},{"title":"ApplyAndView.htm <span style='color:#111;'> 1.18KB </span>","children":null,"spread":false},{"title":"xUndoTransLE.htm <span style='color:#111;'> 1.18KB </span>","children":null,"spread":false},{"title":"Solve.htm <span style='color:#111;'> 1.17KB </span>","children":null,"spread":false},{"title":"xAuditChanges.htm <span style='color:#111;'> 1.16KB </span>","children":null,"spread":false},{"title":"xRestoreRow.htm <span style='color:#111;'> 1.14KB </span>","children":null,"spread":false},{"title":"PopulateTable.htm <span style='color:#111;'> 1.13KB </span>","children":null,"spread":false},{"title":"xAuditExport.htm <span style='color:#111;'> 1.12KB </span>","children":null,"spread":false},{"title":"xAuditUsers.htm <span style='color:#111;'> 1.09KB </span>","children":null,"spread":false},{"title":"Setup.htm <span style='color:#111;'> 1.09KB </span>","children":null,"spread":false},{"title":"ComplexTrans.htm <span style='color:#111;'> 1.08KB </span>","children":null,"spread":false},{"title":"RecoverDroppedTable.htm <span style='color:#111;'> 1.07KB </span>","children":null,"spread":false},{"title":"xRecoverRepair.htm <span style='color:#111;'> 1.04KB </span>","children":null,"spread":false},{"title":"xRealTimeMonitorExample.htm <span style='color:#111;'> 1.02KB </span>","children":null,"spread":false},{"title":"xPopulateTable.htm <span style='color:#111;'> 1.02KB </span>","children":null,"spread":false},{"title":"xDemoOverview.htm <span style='color:#111;'> 1024B </span>","children":null,"spread":false},{"title":"xApplyAndView.htm <span style='color:#111;'> 1019B </span>","children":null,"spread":false},{"title":"ApplyUndoTrans.htm <span style='color:#111;'> 1002B </span>","children":null,"spread":false},{"title":"xAudit.htm <span style='color:#111;'> 985B </span>","children":null,"spread":false},{"title":"ConnectPre.htm <span style='color:#111;'> 955B </span>","children":null,"spread":false},{"title":"xFindProblem.htm <span style='color:#111;'> 951B </span>","children":null,"spread":false},{"title":"xFindProblem2.htm <span style='color:#111;'> 925B </span>","children":null,"spread":false},{"title":"xRecoverDroppedTable.htm <span style='color:#111;'> 906B </span>","children":null,"spread":false},{"title":"RealTimeMonitor.htm <span style='color:#111;'> 901B </span>","children":null,"spread":false},{"title":"Audit.htm <span style='color:#111;'> 887B </span>","children":null,"spread":false},{"title":"xfaq.htm <span style='color:#111;'> 886B </span>","children":null,"spread":false},{"title":"xSolveSetup.htm <span style='color:#111;'> 842B </span>","children":null,"spread":false},{"title":"UndoTransaction.htm <span style='color:#111;'> 833B </span>","children":null,"spread":false},{"title":"Manage.htm <span style='color:#111;'> 822B </span>","children":null,"spread":false},{"title":"xRealTimeMonitor.htm <span style='color:#111;'> 818B </span>","children":null,"spread":false},{"title":"xSolve.htm <span style='color:#111;'> 808B </span>","children":null,"spread":false},{"title":"xSetup.htm <span style='color:#111;'> 803B </span>","children":null,"spread":false},{"title":"xUndoTransaction.htm <span style='color:#111;'> 782B </span>","children":null,"spread":false},{"title":"xRunLogExplorer.htm <span style='color:#111;'> 782B </span>","children":null,"spread":false},{"title":"AnalyzeBehavior.htm <span style='color:#111;'> 763B </span>","children":null,"spread":false},{"title":"xManage.htm <span style='color:#111;'> 762B </span>","children":null,"spread":false},{"title":"RecoverTableTop.htm <span style='color:#111;'> 760B </span>","children":null,"spread":false},{"title":"xCreateSchemaPre.htm <span style='color:#111;'> 744B </span>","children":null,"spread":false},{"title":"xComplexTrans.htm <span style='color:#111;'> 743B </span>","children":null,"spread":false},{"title":"PopulateTablePost.htm <span style='color:#111;'> 728B </span>","children":null,"spread":false},{"title":"xAnalyzeBehavior.htm <span style='color:#111;'> 704B </span>","children":null,"spread":false},{"title":"xApplyUndoTrans.htm <span style='color:#111;'> 701B </span>","children":null,"spread":false},{"title":"xPopulateTablePost.htm <span style='color:#111;'> 693B </span>","children":null,"spread":false},{"title":"xNoLogExplorer.htm <span style='color:#111;'> 681B </span>","children":null,"spread":false},{"title":"xConnectPre.htm <span style='color:#111;'> 672B </span>","children":null,"spread":false},{"title":"xRecoverTableTop.htm <span style='color:#111;'> 664B </span>","children":null,"spread":false},{"title":"DropTableDoit.htm <span style='color:#111;'> 660B </span>","children":null,"spread":false},{"title":"NotFound.htm <span style='color:#111;'> 589B </span>","children":null,"spread":false},{"title":"xDropTableDoit.htm <span style='color:#111;'> 573B </span>","children":null,"spread":false},{"title":"xthanks.htm <span style='color:#111;'> 344B </span>","children":null,"spread":false},{"title":"thanks.htm <span style='color:#111;'> 342B </span>","children":null,"spread":false},{"title":"xWelcome.htm <span style='color:#111;'> 338B </span>","children":null,"spread":false},{"title":"Welcome.htm <span style='color:#111;'> 335B </span>","children":null,"spread":false},{"title":"......","children":null,"spread":false},{"title":"<span style='color:steelblue;'>文件过多，未全部展示</span>","children":null,"spread":false}],"spread":true}]

评论信息

其他资源

免责申明

【只为小站】的资源来自网友分享，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论 【只为小站】 经营者是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明

个人信息

下载历史

相关资源标签

热门下载

最新下载