Monday, September 28, 2009

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

use 資料庫名稱

Backup Log 資料庫名稱 with TRUNCATE_ONLY

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

Posted by at No comments:
Labels:
Subscribe to: Posts (Atom)