事务日志文件已满 [英] transaction log file is full

问题描述

数据库事务日志文件已满。我无法删除日志文件。当我尝试进行备份时，它会抛出错误。任何其他方式，以便我可以写任何没有任何问题的交易。请回复问题紧急。

Hi,

The database transaction log file is full. I cannot delete the log file. when I try to take backup it throws error. Any other way so that I can write more transaction without any problem. Please reply matter is urgent.

推荐答案

您使用什么查询来备份事务日志？以下应该有效。


备份日志<您的数据库名称> with truncate_only

What query did you use to backup the transaction log? The following should work.

backup log <your database name> with truncate_only

检查磁盘上是否有足够的空间来备份日志。否则，将日志备份到其他驱动器。如果有足够的磁盘空间，您还可以将数据库设置为自动增长。

Check that there is enough space on the disk to back the log up. Otherwise back the log up to a different drive. You can also set the database to auto grow if there is enough disk space.

数据库事务日志文件已满。我无法删除日志文件。当我尝试进行备份时，它会抛出错误。任何其他方式，以便我可以写任何没有任何问题的交易。请回复紧急事项。

Hi,

The database transaction log file is full. I cannot delete the log file. when I try to take backup it throws error. Any other way so that I can write more transaction without any problem. Please reply matter is urgent.

嗨Sona，

我也遇到了同样的问题。在我的情况下有2个原因。


1）日志文件的大小限制为2 MB，日志已经增长到这个大小。通过备份Log，可以减小大小。如果磁盘空间不足，则在备份期间会再次出错。

Hi Sona,
I too have faced the same problem. In my case there were 2 causes.

1)The size of log file was restricted to 2 MB and the log had already grown to this size. By taking the backup of the Log the size could be decreased. If the disk is out of space it would again give an error during backup.

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