å¦æä½ çæ°æ®åºæ¯å®å
¨æ¢å¤æ¨¡å¼çè¯ï¼å¯ä»¥éè¿log Explorer,æ¥çã
å
·ä½ä½¿ç¨æç´¢ä¸ä¸å°±æã
使ç¨Log Exploreræ¥çåæ¢å¤æ°æ®
Log Explorer 4.1.å¯ç¨äºSQL Server2005çæ¥å¿æ¥çå·¥å
·
使ç¨æ¹æ³:
æå¼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"->çæè¯å¥->æ¥è¯¢åæå¨éæ§è¡
----------------------------------------------------------------------
--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æ¢å¤æ°æ®
温馨提示:答案为网友推荐,仅供参考