|
[2003-01-17±Ý] 1. ÃÊÀçÁø »êÁ¤½Ã ÀϹÝÀÏÀÚ´Â Á¦¿ÜÇÏ°Ô -±è±â¹ü [2003-01-15¼ö] 1. Á¢¼ö½Ã º¸Çè°ü·Ã ºÎºÐ°ú Á¢¼öº¸Ç豸ºÐÀÌ »óÀÌÇÏ¸é ¿¡·¯¸Þ¼¼Áö Ãß°¡ -À̹é¿ë 2. °¡°èµµ¿¡¼ ÇÑ±Û Åä±Û -À̹é¿ë 3. °¡°èµµ ¸Þ¸ð,Àü´Þ»çÇ× Ãß°¡ -À̹é¿ë 4. ÀÚ°ÝÁ¶È¸ ´ÜÃàÅ° (Ctrl + F1) -À̹é¿ë 5. °¡°èµµ¿¡¼ ÁֹιøÈ£ ÀÚµ¿ ÀÔ·Â -À̹é¿ë 6. ÀÚ°ÝÁ¶È¸ º¸È£2Á¾ÀÌ 1Á¾ÀÌ µÇ´Â ¹ö±× -À̹é¿ë [2003-01-14È] 1. °Ë»ç½Ç¿¡¼ ¹Ù·Î È®ÀιöÆ° Ãß°¡ -±èº´±¹ 2. ÀÔ¿ø°è»ê¼¿¡¼ ¼ö³³±Ý¾× Á¶Á¤½Ã Àû¿ëµÇµµ·Ï -±èº´±¹ 3. ¿ë¹ý±âº»°ª ¼³Á¤ ÇÒ¼ö ÀÖ°Ô -±èº´±¹ 4. °Ë»çÁö½Ã¾ø¾îµµ ÀúÀåµÇ°Ô -±èº´±¹ 5. ·çƾ, ¸®ÇÇÆ®½Ã ¸Þ¸ð³ª Á¶Á¦½ÃÂü°í»çÇ×Àº ¸íĪµµ °°ÀÌ µÇ°Ô -±èº´±¹ 6. ¿ù»ç¿ëÇöȲ ºü¸£°Ô -±èº´±¹ 7. ÃÆ®ÀúÀå ¼ö³³°è»êâ¿¡¼ ¼ö³³±Ý¾×º¯°æ¸¸ ÇÏ¿©µµ DC·Î »êÁ¤µÇ°Ô -±èº´±¹ -Àü¿¡´Â ¿£Å͸¦ ó¾ß¸¸ Çߴµ¥ ±Ý¾×À» »ç¿ëÀÚ°¡ ¹Ù²Ù¸é ÀÚµ¿À¸·Î ÇÏ°Ô 8. ¼³Á¤¿¡ ÀÇÇØ ÃÆ® ÀúÀå½Ã ºÐ·ù ¼ÒÆ®µÇ°Ô -±èº´±¹ -0.Àû¿ë ¾ÊÇÔ, 1.Áõ»ó¸¸ À§·Î, 2.Áõ»óÀ§ ºÐ·ù·Î, 3.Áõ»ó¸¸ ¾Æ·¡·Î, 4.Áõ»ó¾Æ·¡ ºÐ·ù·Î |
|
|
|
ȸé½É»ç¿¡¼ ƯÁ¤È¯ÀÚ ºÒ·¯¿ÀÁö ¾Ê´Â°Í ¼öÁ¤ À̸§»öÀÎ ¼öÁ¤ Åë°è À̸§»öÀÎ ¼öÁ¤ |
|
|
|
Åë°è ÃֽŹöÁ¯ |
|
|
|
backup log nixsql with no_log DBCC SHRINKDATABASE (nixsql, 10)
µÎ°³ ¸ðµÎ ºí·°À» Àâ°í ½ÇÇàÇÏ¸é ·Î±×ÈÀÏÀÌ ¾ÐÃ൷´Ù. |
|
|
|
1. ó¹æÀü ±³ºÎ¹øÈ£ ¼öÁ¤ÈÄ Ãâ·Â½Ã ¹Ù·Î Àû¿ëµÇ°Ô -±èº´±¹ 2. ¹æ»ç¼±Áö½Ã¿¡¼ ºñ±Þ¿©½Ã ÃÔ¿µÈ½¼ö(¿ë¹ý)¿¡ "0"À» ±âÀÔÇÏ¸é ¾È³ª¿À°Ô -±è±â¹ü 3. ¹æ»ç¼±Áö½Ãȸ鿡¼ ¹æ»ç¼± ¸íĪ ¾È³ª¿À°í ¿ë¹ý¸¸ ³ª¿À°Ô -±è±â¹ü 4. ¼³Á¤¿¡ ÃÆ®¿¡¼ ±âÃÊ°Ë»ç´ë½Å °¡°èµµ°¡ ¸ÕÀú º¸ÀÌ°Ô Ãß°¡ -±è±â¹ü 5. Åð¿ø³¯ ¾àÀÌ ¾ø¾îµµ ÀǾàÇ°°ü¸®·á »êÁ¤µÇ°Ô -±è±â¹ü |
|
|
|
|
|