今天部门经理问我如何截断SQL SERVER的日志文件，刚好之前有做过，如下：
1。DBCC SHRINKFILE (DataFil1, 7)： 其中datafil1为你要收缩的日志文件名，或者用文件号去代替，一般日志文件号问2， 7为你要收缩到的大小，这里是7MB
2。backup log database_name with no_log
3。设定database的recovery mode为simple,但这种方法是永久性的，且已经增长的日志没办法立即截断
搜索本站
站点日历
订阅本站
文章分类
- upgrade
- 一些事
- 2010第一贴
- 用BBED修复坏块
- 93分
- 没有眼镜真不方便
- 还是换了
- 如何看到本站的图片
- 有图有真相
- 坚持跑步
- try 1 try
- ANS1312E (RC12) Server media mount not possible
- ORA-12528: TNS:listener: all appropriate instances are blocking new connections
- 项目介绍：一客户MES系统升级
- ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
最新日志
- expdp常见用法 (6,335)
- IMP-00010: 不是有效的导出文件，标题验证失败 (5,056)
- ORA-12500: TNS: 监听程序无法启动专用服务器进程 (3,904)
- ORA-01102: cannot mount database in EXCLUSIVE mode (3,503)
- 一则ora-03113错误的解决 (3,427)
- Checking monitor:must be configured to display at least 256 colors (3,285)
- ORA-12545:Connect failed because target host or object does not exist (3,202)
- CRS无法启动的解决过程 (2,657)
- ORA-02019: connection description for remote database not found (2,469)
- ORA-12535: TNS: 操作超时 (2,237)
- 【ZT】Oracle分布式事务故障处理 (2,132)
- ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid (2,093)
- ORA-00600: internal error code, arguments: [17285], [0x2A97446380], [4294967295], [0x1DD7B1238] (2,082)
- Choosing an I/O Scheduler for Red Hat® Enterprise Linux® 4 and the 2.6 Kernel (1,899)
- 苏州圆融时代广场 (1,872)
- WARNING: inbound connection timed out (ORA-3136) (1,864)
- Oracle CRS log (1,861)
- ORA-12528: TNS:listener: all appropriate instances are blocking new connections (1,798)
- Oracle RAC升级问题记录 (1,628)
- 主键约束引起ORA-02429错误 (1,546)
No Comments
Be the first to comment on this entry.
Leave a comment
Fields in bold are required. Email addresses are never published or distributed.
Some HTML code is allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>URLs must be fully qualified (eg: http://www.dbifan.com),and all tags must be properly closed.
Line breaks and paragraphs are automatically converted.
Please keep comments relevant. Off-topic, offensive or inappropriate comments may be edited or removed.