壓縮LOG檔

出自TSK WIKI
於 2015年12月12日 (六) 09:44 由 Root​(留言 | 貢獻) 所做的修訂 (新頁面: ==程式碼== <SQL> USE LSDTEST; GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE LSDTEST SET RECOVERY SIMPLE; GO -- Shrink the truncated log fi...)
(差異) ←上個修訂 | 最新修訂 (差異) | 下個修訂→ (差異)
跳至導覽 跳至搜尋

程式碼

<SQL> USE LSDTEST; GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE LSDTEST SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 10 MB. DBCC SHRINKFILE ([LSDTEST_log], 10); GO -- Reset the database recovery model. ALTER DATABASE LSDTEST SET RECOVERY FULL; GO </SQL>