mssql 2000 Æ®·£Àè¼Ç ·Î±×ÆÄÀÏÀÌ ÁÙ¾îµéÁö°¡ ¾Ê½À´Ï´Ù. Áö±Ý ´ë·® µ¥ÀÌÅ͸¦ »èÁ¦ÇØ¾ß ÇÏ´Â »óȲÀÔ´Ï´Ù.
·Î±×¸¦ ¾Æ¹«¸® ¹é¾÷ ¹Þ¾Æµµ ÆÄÀÏÀÌ ÁÙ¾îµéÁö°¡ ¾Ê½À´Ï´Ù. BACKUP LOG db ¸í WITH NO_LOG, truncate only µµ Çغ¸°í ¹é¾÷ µð½ºÅ©¸¦ ÁöÁ¤Çؼ ¹é¾÷µµ ¹Þ¾Æ ºÃ½À´Ï´Ù.
SHRINKFILE,DB ½ÇÇàÇÏ¸é ¸ðµç ³í¸® ·Î±× ÆÄÀÏÀÌ »ç¿ë ÁßÀ̹ǷΠ·Î±× ÆÄÀÏ 2(_Log)À»(¸¦) Ãà¼ÒÇÒ ¼ö ¾ø½À´Ï´Ù. ¶ó°í ³ª¿É´Ï´Ù.
º¹±¸ ¸ðµ¨À» ´Ü¼øÀ¸·Î º¯°æÇÏ°í ´Ù½Ã Àüü·Îµµ ÇغÃÀ¸³ª ¿©ÀüÈ÷ ¾È µË´Ï´Ù. µµ¿ò ºÎŹµå¸³´Ï´Ù.
| |
|
Go
ALTER DATABASE µ¥ÀÌÅͺ£À̽º¸í SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE(·Î±×ÆÄÀϸí, ¿øÇÏ´ÂÅ©±â)
GO
ALTER DATABASE µ¥ÀÌÅͺ£À̽º¸í SET RECOVERY FULL
GO