日志文件很大 [英] Log file size is huge

问题描述

我们有一个数据库，我们每天做很多交易，所以日志文件大小增长太多，我尝试缩小它但没有减少..

We have one database and we do lot many transactios per day, so the log file size growing too much, and i have tried shrinking it but its not reducing..

我该怎么做才能减小日志文件的大小.(我们做了太多的插入)

What shall i do to reduce the log file size. (We do too many inserts)

谢谢斯里尼瓦斯

推荐答案

你有一个数据库 使用完整"恢复模式，并且没有运行日志备份.

You have a database with "Full" recovery model and no log backups running.

设置为简单恢复模式或设置日志备份.没有其他正确选择(例如缩小或截断).上面的链接也有其他文章的链接.

Either set to simple recovery model or set up log backups. There are no other correct choices (such as shrinking or truncating). The link above has links to other articles too.

这篇关于日志文件很大的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！