SysTools SQL Log Analyzer 6.0 SysToolsSQLLogAnalyzer是一款好用的sql數據庫日誌分析工具,可以有效地對ldf、mdf日誌文件進行分析操作,軟件還可以連接到sql數據庫進行各類事件的分析操作,可以自動獲取相應的記錄,包括插入、更新、刪除等,除此之外,還可以掃瞄損壞的SQLServer數據庫進行恢復 AnalyzeactivityinyourSQLServereitherbydirectlyconnectingtothedatabase,orbytakingalookattheLDFandMDFlogfilepair.Servicesusuallykeeplargequantitiesofinformationinsidedatabases.Therearevarioustypesofdatabases,andevenmoreassociatedtoolstocomfortablyperformrelatedservertasks.Forinstance,SysToolsSQLLogAnalyzeristhetypeofapplicationwhichcanconnecttoyourSQLdatabasesinanattempttoanalyzerelatedtransactions,andevenofflinelogfiles. AnalyzeSQLlogfiletransactions&quicklyperformSQLldffilerecovery Preview.ldfActivity:Transaction,Time,Name,TableName,&Query Read&AnalyzeAllTransactionslike:INSERT,DELETE,UPDATEetc. SupportedDataTypes:Datetime2,datetimeoffset,sql_variant,hierarchyid,geometry&geographydatatypes. QuickScan,ViewLDFfileandAutolocateassociatedMDFfile Providessupporttofetch&viewrecordsfromLivedatabase RecoverDeletedRecordsifdatabaseisinSimpleRecoveryMode. OptiontoFilter&ExportasSQLDatabase,asSQLScriptorasCSVFile ProvidesSupporttoAnalyzeMultipleNDFFiledata MDFFileisrequiredtoanalyzethedatabase Thetoolworksbothonline&offlineSQLdatabaseenvironment SupportedUnicode(collation)datatablesafterexport SupportsSQLServer2017,2016,2014,2012,2008andSQLServer2005LDFFiles