壓縮LOG檔

出自TSK WIKI
跳至導覽 跳至搜尋

程式碼

  • 壓縮交易記錄檔

<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>

  • 檔案位置
    • D:\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA