Shunze ¾Ç¶é (http://www.shunze.info/forum/index.php)
|- ¸ê®Æ®wºÞ²z (http://www.shunze.info/forum/board.php?boardid=28)
|-- ¡m¤À¨É¡nMS SQL®t²§³Æ¥÷¦p¦óÁÙ­ì (http://www.shunze.info/forum/threadid.php?boardid=28&threadid=1707)


§@ªÌ: shunze µoªí®É¶¡: 2013-04-06, 22:45:

¡m¤À¨É¡nMS SQL®t²§³Æ¥÷¦p¦óÁÙ­ì

·íMS SQL¸ê®Æ®wªº®t²§³Æ¥÷»P¹ïÀ³ªº§¹¾ã³Æ¥÷­Y¬O¦b¦P¤@­ÓÀɮפW¡A
³z¹LUI¤¶­±ÁÙ­ì®t²§³Æ¥÷®É¡A¥u­n¤Ä¿ï¦n±z­nÁ٭쪺®t²§³Æ¥÷ÂI¡A
§Y¥i»´ÃPÁÙ­ì¨ì¦¹®t²§³Æ¥÷ÂI¡C




¦ý¦pªG§¹¾ã³Æ¥÷»P®t²§³Æ¥÷¬O¤£¦PÀɮתº¸Ü¡A
¦bÁÙ­ì¾Þ§@¤W´N¥²»Ý°µÂIÅܤơI

¦]¬°­Y¬Oª½±µÁÙ­ì®t²§³Æ¥÷ÀÉ¡A·|¦]¨S¦³¹ïÀ³ªº§¹¾ã³Æ¥÷¸ê®Æ¡A¦Ó¥¢±Ñ¡I





¿ù»~°T®§-µLªkÁÙ­ì°O¿ý©Î®t²§³Æ¥÷¡C¦]¬°¨S¦³¥i¦V«e´_­ìªºÀɮסC

­Y¬O¥ýÁÙ­ì¹ïÀ³ªº§¹¾ã³Æ¥÷¸ê®Æ¡AµM«á¦AÁÙ­ì®t²§³Æ¥÷¡A¤]·|¥X²{¤@¼Ëªº¿ù»~¡C



¨º¨s³º­n¦p¦óÁ٭줣¦PÀɮתº®t³Æ¥÷©O¡H

³z¹L¸ê®Æ®wªºT-SQLÁÙ­ì®t²§³Æ¥÷»yªk¦p¤U¡A

RESTORE DATABASE ¸ê®Æ®w¦WºÙ FROM disk='§¹¾ã³Æ¥÷ªºÀɮ׸ô®|' WITH NORECOVERY
RESTORE DATABASE ¸ê®Æ®w¦WºÙ FROM disk='®t²§³Æ¥÷ªºÀɮ׸ô®|' WITH RECOVERY

¦b§¹¾ã³Æ¥÷ùØ¥[¤WWITH NORECOVERY¡A¼È®ÉÅý¸ê®Æ®w¤£¹B§@¡A¥B¤£¦^´_¥¼»{¥i¥æ©ö¡F
µM«áºò±µµÛ¦b®t²§³Æ¥÷¤¤¥[¤WWITH RECOVERY°Ñ¼Æ¡A¦^´_¥æ©ö¡A¨ÃÅý¸ê®Æ®w¤W½u¡A
³o¼Ë´N¥i¥H¶i¦æ¤£¦PÀɮתº®t²§³Æ¥÷¦^´_¤F¡ã



³z¹LUI¤¶­±¸òT-SQL¨ÓÁ٭줣¦PÀɮתº®t²§³Æ¥÷¡A­n°µªº¨Æ¨ä¹ê¬O¤@¼Ëªº¡A
¥u¬O¦bUI¾Þ§@¤W¡A§Ú­Ì¥²»Ý¦b¿ï¶µ¤W°µÂI³]©w¡C

­º¥ý­n¥ýÁÙ­ì¹ïÀ³ªº§¹¾ã³Æ¥÷¡A



¨Ã¤Ä¿ï¿ï¶µ-Åý¸ê®Æ®w«O«ù¤£¹B§@¡A¥B¤£¦^´_¥¼»{¥iªº¥æ©ö¡C



³o®É¸ê®Æ´N·|¥X²{¥¿¦bÁ٭쪺ª¬ºA¡A¨Ã¤¹³\Ä~Äò°õ¦æ®t²§³Æ¥÷¡C



±µµÛ¿ï¾Ü­nÁ٭쪺®t²§³Æ¥÷ÀÉ¡A



¿ï¶µ´N¿ï¾Ü¹w³]ªº-¦^´_¥¼»{¥i¥æ©ö¡C



³o¼Ë´N¥i¥H¶¶§QÁÙ­ì®t²§³Æ¥÷¡ã

Powered by: Burning Board 1.1.1 2001 by WoltLab
Taiwan Translation by Achi