Shunze ¾Ç¶é >¹q¸£¸ê°T¾Ç¨t >¸ê®Æ®wºÞ²z > ¡m¤À¨É¡nMS SQL¥æ©ö°O¿ýÀÉ´îªÎ «¢Å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¥æ©ö°O¿ýÀÉ´îªÎ¤Þ¥Î¦^ÂÐ ½s¿è/§R°£¤å³¹ ·j´M¥Ñ  µoªíªº¨ä¥L¤å³¹ ¦^³øµ¹ª©¥D IP ¦ì¸m ¦^¦¹­¶³Ì¤W¤è

MS SQLªº´_­ì¼Ò¦¡Á`¦@¦³§¹¾ã¡B²³æ¤Î¤j¶q°O¿ýµ¥¤TºØ¡C



²³æ¼Ò¦¡µL¥æ©ö°O¿ýÀÉ¡AªÅ¶¡»Ý¨D§C¡F
§¹¾ã¼Ò¦¡¦³¥æ©ö°O¿ýÀÉ¡AªÅ¶¡»Ý¨D¤j¡A¦ý·l¥¢§C¡F
¤j¶q°O¿ý¼Ò¦¡¦³¥æ©ö°O¿ýÀÉ¡AªÅ¶¡»Ý¨D¤j¡A¦ý·l¥¢§C¡C

¸Ô²Ó¥i°Ñ¦Ò·L³nºô¯¸
http://msdn.microsoft.com/zh-tw/library/ms189275.aspx


¦b¹w³]±¡ªp¤U¡A¸ê®Æ®wªº´_­ì¼Ò¦¡¬O§¹¾ã¼Ò¦¡¡A
©Ò¥H¥æ©ö°O¿ýÀÉ·|¤@ª½¦¨ªø¡A³Ì«áºtÅܦ¨¸ê®Æ®w©ú©ú¥u¦³´XM¡A¦ý¥æ©ö°O¿ýÀÉ«o¦³´XGªº©Ç²{¶H¡C







¨º­n¦p¦ó´À¥æ©ö°O¿ýÀÉ´îªÎ©O¡H
MS SQL¥¿½T§@ªk¬O­n´À¥æ©ö°O¿ýÀÉ°µ³Æ¥÷¡C

³Æ¥÷¡H
³Æ¥÷¸ò´îªÎ¦³¤°»òÃö«Y©O¡H

¦]¬°§¹¾ã¼Ò¦¡¤U¡A¥æ©ö°O¿ýÀÉ·|¤£Â_¦¨ªø¡A
©Ò¥H¥²»Ý³z¹L³Æ¥÷ªº°Ê§@¡A¨Ó§i¶D¸ê®Æ®w¡A¥æ©ö°O¿ýÀɤw¸g¦³³Æ¥÷¤F¡A
¥æ©ö°O¿ýÀÉ¥i¥H±qÀY¨Ó¹L¡ã



¦b¥æ©ö°O¿ýÀɦ¨¥\³Æ¥÷ªº±¡ªp¤U¡A¥æ©ö°O¿ýÀÉ·|±qÀY¶}©l°O¿ý¡A
¦]¦¹°t¸mªÅ¶¡¥i¥H­«ÂШϥΡA¨Ï±o¥æ©ö°O¿ýÀɤ£·|±q«á­±¤@ª½ªþ¥[¤W¥h¡A³y¦¨¥æ©ö°O¿ýÀɪΤjªº²{¶H¡C

©Ò¥H¥¿½T¨Ó»¡¡A°£¤F©w´Á³Æ¥÷¸ê®Æ®w¥~¡A
¥æ©ö°O¿ýÀɤ]À³¸Ó­nÀHµÛ¸ê®Æ©w´Á³Æ¥÷¡C
³o¼Ë¤~¤£·|³y¦¨¸ê®Æ®w«Ü¤p¡A¦ý¥æ©ö°O¿ýÀÉ«o¬O¶W¯ÅªÎ¤jªº²{¶H¡I



¨º¥æ©ö°O¿ýÀɤw¸g«ÜªÎ¤j¤F¡A
°µ§¹¥æ©ö°O¿ýÀɳƥ÷«á¡A¥æ©ö°O¿ýÀÉÁÙ¬O«Ü¤j¡A¤£·|Åܤp«ç»ò¿ì¡H

³o­Ó³¡¥÷­n³z¹L¥H¤U«ü¥O¨Ó§¹¦¨(DB-NAME¬°¸ê®Æ®w¦WºÙ)¡C
backup log DB-NAME with no_log



¾Þ§@¥H¤W«ü¥O«á¡A´N¯à´À¸ê®Æ®w¶i¦æªÅ¶¡À£ÁY´îªÎ¤F¡ã





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

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




2011-10-19, 11:14 shunze ªº­Ó¤H¸ê®Æ §â shunze ¥[¤J¦n¤Í¦Cªí µo°eEmailµ¹ shunze ÂsÄý shunze ªººô¯¸ MSN : shunze@gmail.com
shunze
¤u¤Í§B§B


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

shunze Â÷½u
MS SQL 2008ªº¤£¦PÂI¤Þ¥Î¦^ÂÐ ½s¿è/§R°£¤å³¹ ·j´M¥Ñ  µoªíªº¨ä¥L¤å³¹ ¦^³øµ¹ª©¥D IP ¦ì¸m ¦^¦¹­¶³Ì¤W¤è

¸g´ú¸Õ¡ASQL 2005ªº»yªk¦b2008¤w¤£¯à¨Ï¥Î

backup log DB-NAME with no_log


SQL 2008ªº»yªk§ï¬°¦p¤U
backup log DB-NAME TO DISK='NUL:'


»yªk°õ¦æ«á¤@¼Ë­n¦b¤u§@ùرN¥æ©ö°O¿ýÀÉÀ£ÁY³á¡ã



♥¶¶¤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-02-21, 11:00 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