错误:事务日志已满. [英] Error: Transaction log is full.

问题描述

The transaction log for database 'britco_dbase' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases.

当我进入网站时会出现此错误，因此我与rds服务器聊天并清除了日志文件.时间会解决.但是几天后，当我们插入新数据时，也会出现相同的错误.那么如何永久解决此问题?

This error comes when i take the website,So i chat with the rds server and they clear the log file.At that time it will be solved.But after some days, when we insert new data,then also the same error comes.So how to solve this problem permanently?

推荐答案

执行数据库的常规备份\ TLogs

http://msdn.microsoft.com/en-us/library/ms175495.aspx [ ^ ]

http://msdn.microsoft.com/en-us/library/ms179478.aspx [ ^ ]

根据您的应用程序正在处理的事务数量(以及您有多少磁盘空间等！)，您应该执行常规备份.

如果您不希望这种级别的灾难恢复，则可以考虑将数据库模型更改为简单".这意味着您将只能将数据库还原到最后一次已知的完整备份"，而不是常规TLog备份所提供的时间点恢复.在这种情况下，您应该有一个自动化的作业，它正在创建完整的数据库备份(维护计划等)

Perform regular backups of your database \ TLogs

http://msdn.microsoft.com/en-us/library/ms175495.aspx[^]

http://msdn.microsoft.com/en-us/library/ms179478.aspx[^]

Depending on how many transactions your application is processing (and how much disk space you have etc!) you should be performing regular backups.

If you don''t want this level of disaster recovery, you could consider changing your database model to ''Simple''. This means you''d only be able to restore your database to ''last known full backup'', rather than point-in-time recovery that regular TLog backups offer. In this case, you should have an automated job that''s creating a full db backup (maintenance plan etc)

这篇关于错误:事务日志已满.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！