å¨SQL Serverä¸ç»å¸¸éå°äºå¡æ¥å¿å大çæ
åµï¼é¤äºå°æ°æ®åºè®¾ç½®ä¸ºâèªå¨æ¶ç¼©âå¤ï¼è¿å¯ä»¥ä½¿ç¨ä¸é¢çSQLå½ä»¤è¿è¡å¿«éæ¸
é¤æ°æ®åºä¸çäºå¡æ¥å¿ï¼å½ä»¤å¦ä¸ï¼
- 第ä¸æ¥ï¼æ¸
空æ¥å¿
DUMP TRANSACTION
databasename
WITH
NO_LOG
-- 第äºæ¥ï¼æªæäºå¡æ¥å¿
BACKUP LOG
databasename
WITH
NO_LOG
-- 第ä¸æ¥ï¼æ¶ç¼©æ°æ®åº
DBCC SHRINKDATABASE(databasename)
éè¦è¯´æå ç¹ï¼
1. ä¸é¢çSQLå½ä»¤éè¦æç
§é¡ºåºæ§è¡ï¼
2. æ§è¡ä¸é¢çå½ä»¤é常æ¯ç´æ¥ä½¿ç¨å³é®èåä¸çâæ¶ç¼©âå½ä»¤è¦å¿«å¾å¤
åèèµæï¼
SQL SERVER æ°æ®åºæ¥å¿å·²æ»¡ï¼å¦ä½æ¶ç¼©æ°æ®åºæ¥å¿
http://blog.csdn.net/faintbear/archive/2005/02/06/283316.aspxå¦ä½æ¶ç¼©æ°æ®åºæ¥å¿
http://www.cndiy8.com/data/web5701/20050228/20050228__3794589.html