Monday, September 28, 2009

sql server log檔太大如何清除 with sql 2000

use 資料庫名稱

Backup Log 資料庫名稱 with TRUNCATE_ONLY

dbcc shrinkfile (資料庫名稱_log , truncateonly)

Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)