Shunze ¾Ç¶é >¹q¸£¸ê°T¾Ç¨t >¸ê®Æ®wºÞ²z > ¡m¤À¨É¡nMS SQL®t²§³Æ¥÷¦p¦óÁÙ­ì «¢Åo¡AÁÙ¨S¦³µù¥U©ÎªÌµn¤J¡C½Ð§A[µù¥U|µn¤J]
« ¤W¤@½g¥DÃD ¤U¤@½g¥DÃD » Åã¥Ü¦¨¦C¦L¼Ò¦¡ | ¼W¥[¨ì§Úªº³Ì·R
µoªí·s¥DÃD µoªí¦^ÂÐ
§@ªÌ
¥DÃD
shunze
¤u¤Í§B§B


µù¥U¤é´Á: 2002 04
¨Ó¦Û: ¼é¦Á²×¤î¤§¦a
¤å³¹: 2370

shunze Â÷½u
¡m¤À¨É¡nMS SQL®t²§³Æ¥÷¦p¦óÁÙ­ì¤Þ¥Î¦^ÂÐ ½s¿è/§R°£¤å³¹ ·j´M¥Ñ  µoªíªº¨ä¥L¤å³¹ ¦^³øµ¹ª©¥D IP ¦ì¸m ¦^¦¹­¶³Ì¤W¤è

·í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²§³Æ¥÷¡ã



♥¶¶¤l¦Ñ±Cªººô©ç¡A½Ð¦hÃö·Ó¡ã

If you don't like something, change it.
If you can't change it, change your attitude.
Don't complain!




2013-04-06, 22:45 shunze ªº­Ó¤H¸ê®Æ §â shunze ¥[¤J¦n¤Í¦Cªí µo°eEmailµ¹ shunze ÂsÄý shunze ªººô¯¸ MSN : shunze@gmail.com
  « ¤W¤@½g¥DÃD ¤U¤@½g¥DÃD »
µoªí·s¥DÃD µoªí¦^ÂÐ
¸õ¨ì:

Powered by: Burning Board 1.1.1 2001 WoltLab GbR