SQL Serverä¸è¯¯å é¤æ°æ®çæ¢å¤æ¬æ¥ä¸æ¯ä»¶é¾äºï¼ä»äºå¡æ¥å¿æ¢å¤å³å¯ãä½æ¯ï¼è¿ä¸ªæ¢å¤éè¦æ两个åææ¡ä»¶ï¼
1. è³å°æä¸ä¸ªè¯¯å é¤ä¹åçæ°æ®åºå®å
¨å¤ä»½ã
2. æ°æ®åºçæ¢å¤æ¨¡å¼ï¼Recovery modeï¼æ¯âå®æ´ï¼Fullï¼âã
é对è¿ä¸¤ä¸ªåææ¡ä»¶ï¼ä¼æä¸ç§æ
åµï¼
æ
åµä¸ãå¦æè¿ä¸¤ä¸ªåææ¡ä»¶é½åå¨ï¼éè¿SQLè¯å¥åªéä¸æ¥å°±è½æ¢å¤ï¼åèæç« ï¼ï¼æ éåå©ç¬¬ä¸æ¹å·¥å
·ã
ããa) å¤ä»½å½åæ°æ®åºçäºå¡æ¥å¿ï¼BACKUP LOG [æ°æ®åºå] TO disk= N'å¤ä»½æ件å' WITH NORECOVERY
ããb) æ¢å¤ä¸ä¸ªè¯¯å é¤ä¹åçå®å
¨å¤ä»½ï¼RESTORE DATABASE [æ°æ®åºå] FROM DISK = N'å®å
¨å¤ä»½æ件å' WITH NORECOVERY, REPLACE
ããc) å°æ°æ®åºæ¢å¤è³è¯¯å é¤ä¹åçæ¶é´ç¹ï¼RESTORE LOG [æ°æ®åº] FROM DISK = N'第ä¸æ¥çæ¥å¿å¤ä»½æ件å' WITH STOPAT = N'误å é¤ä¹åçæ¶é´ç¹' , RECOVERY
æ
åµäºãå¦æ第1个åææ¡ä»¶ä¸åå¨ï¼ç¬¬2个åææ¡ä»¶åå¨ï¼éè¦åå©ç¬¬ä¸æ¹å·¥å
·ã
æ
åµä¸ãå¦æ第2个åææ¡ä»¶ä¸åå¨ï¼æ æ³æ¢å¤ãæ以ï¼ä¸å®è¦å°æ°æ®åºæ¢å¤æ¨¡å¼è®¾ç½®ä¸ºâå®æ´ï¼Fullï¼âã
æç°å¨é¢ä¸´çæ¯ç¬¬äºç§æ
åµï¼éè¦æ¾ç¬¬ä¸æ¹å·¥å
·ã
å¼å§æ¾çæ¯Log Explorer for SQL Serverï¼ä¸æ¯æSQL Server 2008ã
åæ¥æ¾çæ¯SQL Log Rescueï¼ä¹ä¸æ¯æSQL Server 2008ã
æ¥çæ¾å°çæ¯SysTools SQL Recoveryï¼æ¯æSQL Server 2008ï¼ä½éè¦è´ä¹°ï¼Demoç并没ææ°æ®æ¢å¤åè½ã
æç»å¨officerecovery.comä¸æ¾å°Recovery for SQL Serverï¼è½ç¶ä¹æ¯åä¸è½¯ä»¶ï¼éè¦è´ä¹°ï¼ä½Demoçå¯ä»¥æ¢å¤æ°æ®ï¼åªè¦æ°æ®åºæ件ä¸è¶
è¿24Gbã幸好æåçæ°æ®åºæ件ä¸å¤§ï¼ç¨å®å®æäºè¯¯å é¤æ°æ®çæ¢å¤ã
ä¸é¢å享ä¸ä¸ç¨Recovery for SQL Serverè¿è¡æ¢å¤çæä½æ¥éª¤ï¼
1. è¿è¡Recovery for SQL Server
2. ç¹å»èåä¸ç File > Recoverï¼éæ©è¦æ¢å¤çæ°æ®åºçæ°æ®æ件ï¼.mdfï¼
3. Next > Nextï¼è¿å
¥ Recovery Configuration çé¢ï¼éæ©Customï¼éæ©äºCustomæå¯ä»¥éæ©ä»æ¥å¿ä¸æ¢å¤è¯¯å é¤çæ°æ®ï¼ã
4. Next è¿å
¥ Recovery options çªå£ï¼éä¸ Search for deleted recordsï¼å¹¶éæ©è¦æ¢å¤çæ°æ®åºçæ¥å¿æ件路å¾ï¼log file pathï¼ã
5. Next 并éæ©ç®æ æ件夹ï¼Destination folderï¼ï¼ç¨äºåæ¾æ¢å¤è¿ç¨ä¸çæçSQLè¯å¥ä¸batæ件ã
6. ç¹å»Startï¼å¼å§æ¢å¤æä½ï¼å¨ä¸ä¸æ¥éæ©çç®æ æ件夹ä¸çæç¸åºçSQLæ件ä¸Batæ件ï¼ï¼ç¶åï¼åºç° SQL Server Database Creation Utility çªå£ã
7. Nextï¼éæ©è¢«æ¢å¤æ°æ®åæ¾çç®æ æ°æ®åºã
8. Next, éæ© Import availiable data from both database and log files
9. Next, Next, ç¶åå°±å®ææ°æ®çæ¢å¤ï¼
温馨提示:内容为网友见解,仅供参考