数据库的日志文件已满 [英] The log file for database is full
问题描述
所以我们的 SQL Server 2000 给了我错误，数据库的日志文件已满.备份数据库的事务日志以释放一些日志空间."
So our SQL Server 2000 is giving me the error, "The log file for database is full. Back up the transaction log for the database to free up some log space."
如何解决这个问题而不像其他一些网站提到的那样删除日志?
How do I go about fixing this without deleting the log like some other sites have mentioned?
附加信息:启用 AutoGrowth 已启用增长 10% 且限制为 40MB.
Additional Info: Enable AutoGrowth is enabled growing by 10% and is restricted to 40MB.
推荐答案
Scott，如您所料:如果您关心数据，截断日志是一个糟糕的举动.
Scott, as you guessed: truncating the log is a bad move if you care about your data.
以下免费视频将帮助您准确了解发生了什么，并向您展示如何在不截断日志的情况下解决问题.(这些视频还解释了为什么这是一个如此危险的黑客行为，以及为什么您寻找其他解决方案是正确的.)
The following, free, videos will help you see exactly what's going on and will show you how to fix the problem without truncating the logs. (These videos also explain why that's such a dangerous hack and why you are right to look for another solution.)
这些视频将帮助您准确了解正在发生的事情，并向您展示您是要切换到简单恢复，还是考虑实际更改备份例程.还有一些额外的操作方法"视频将向您展示如何设置备份以确保可用性，同时管理日志文件大小和增长.
Together these videos will help you understand exactly what's going on and will show you whether you want to switch to SIMPLE recovery, or look into actually changing your backup routines. There are also some additional 'how-to' videos that will show you exactly how to set up your backups to ensure availability while managing log file sizing and growth.
这篇关于数据库的日志文件已满的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
