Sql server 2008 日志满对应的收缩日志的sql
星期日, 2010-03-21 | Author: Lee | Database, JAVA-and-J2EE | 4,278 views
sql如下：
BACKUP LOG dbname to disk=’dbname.log’
DBCC SHRINKFILE (‘dbname_log’,1)
不过要记得执行两遍才可以最终执行收缩;
文章作者: Lee
本文地址： https://www.pomelolee.com/567.html
除非注明，Pomelo Lee文章均为原创，转载请以链接形式标明本文地址
No comments yet.
Leave a comment
Search
相关文章
热门文章
最新文章
文章分类
- ajax (10)
- algorithm-learn (3)
- Android (6)
- as (3)
- computer (85)
- Database (30)
- disucz (4)
- enterprise (1)
- erlang (2)
- flash (5)
- golang (3)
- html5 (18)
- ios (4)
- JAVA-and-J2EE (186)
- linux (143)
- mac (10)
- movie-music (11)
- pagemaker (36)
- php (50)
- spring-boot (2)
- Synology群晖 (2)
- Uncategorized (6)
- unity (1)
- webgame (15)
- wordpress (33)
- work-other (2)
- 体味生活 (40)
- 前端 (21)
- 大数据 (8)
- 游戏开发 (9)
- 爱上海 (19)
- 读书 (4)
- 软件 (3)