「壓縮LOG檔」:修訂間差異
跳至導覽
跳至搜尋
新頁面: ==程式碼== <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... |
|||
| 第1行: | 第1行: | ||
==程式碼== | ==程式碼== | ||
*壓縮交易記錄檔 | |||
<SQL> | <SQL> | ||
USE LSDTEST; | USE LSDTEST; | ||
於 2016年7月15日 (五) 21:28 的修訂
程式碼
- 壓縮交易記錄檔
<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>