sql 2005 收缩日志后，很快就提示 事务日志已满，

Question

sql 2005 收缩日志后，很快就提示 事务日志已满，要在增长那里设回不限才可以正常使用

Answer 1

請問你的資料庫新增、刪除、修改很頻繁嗎?

---

以上說明若有錯誤請指教，謝謝。
http://www.dotblogs.com.tw/terrychuang/

Answer 2

定期做日志备份

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 3

Agree, have to backup log in scheduled intervals if db is not in simple recovery mode. Shrinking file is not the solution.