2007/08/29

clear trancation log - ms sql 2005

BACKUP LOG your_db WITH TRUNCATE_ONLY
DBCC SHRINKFILE(your_db_log, 1) BACKUP LOG your_db WITH TRUNCATE_ONLY

參考:
INF: 如何將 SQL Server 交易記錄檔壓縮

DBCC SHRINKDATABASE (Transact-SQL)

DBCC (Transact-SQL)

沒有留言:

T-SQL 語法風格