backup log 數據庫名稱 with no_log
dbcc shrinkfile (數據庫日志文件邏輯名稱)
例如:
backup log database1 with no_log
dbcc shrinkfile (database1_log)
backup log 數據庫名稱 with no_log
dbcc shrinkfile (數據庫日志文件邏輯名稱)
例如:
backup log database1 with no_log
dbcc shrinkfile (database1_log)