SQL SERVER 事务日志已满 [英] SQL SERVER Transaction log full
问题描述
如何在 SQL SERVER 2005 中释放事务日志空间:
How to free Transaction log space in SQL SERVER 2005:
我有事务日志大小 = 70 GB，并且在不同的驱动器中有四个事务日志 1、2、3、4.通过 DBCC SQLPERF(LOGSPACE) 我发现事务日志已满(使用 100%)，我想释放事务日志中的空间，我不想 T-log 备份.我没有空间来备份事务日志.我的数据库处于复制状态.
I have Transaction log size = 70 GB and there four transaction logs 1,2,3,4 in different drives. Through DBCC SQLPERF(LOGSPACE) I found that the transaction log is Full (uses 100 %) and I want to free up the space in transaction log and I don't want T-log backup. I don't have space to backup the transaction log. And my DB is in Replication state.
- 如何释放事务日志或
- 我可以只有一个日志文件而不是 3 个事务日志文件吗
- 如果收缩方法如何处理复制?
推荐答案
查看来自 Microsoft 的以下文章.
Check the following article from Microsoft.
http://msdn.microsoft.com/en-us/library/ms175495.aspx
我想释放空间事务日志，我不想要 T-log备份
and i want to free up the space in Transaction log and I dont want T-log backup
微软不支持这个.
此处需要事务日志备份.得到驱动器，做它.
Transaction log backup IS NEEDED HERE. Get a drive, do it.
如果你不这样做，你就不能释放日志.
If you don't do it, you can not free the log.
不释放日志就无法缩小文件.因此，无论您愿意与否，您都需要进行备份.
Without freeing the log you can not shrink the files. Ergo, you need to make a backup, whether you want to or not.
如果您不关心事务日志，则应该以简单恢复模式开始创建数据库.
If you don't care about the transaction logs the databases should have been created in simple recovery mode to start with.
这篇关于SQL SERVER 事务日志已满的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
