禁用事务日志 [英] Disable Transaction Log

问题描述

Oracle 有可以发出的 SQL 命令，这样事务就不会被记录.SQL Server 2008 有没有类似的东西?

Oracle has SQL commands that one can issue so that a transaction does not get logged. Is there something similar for SQL Server 2008?

我的场景:我们需要在服务器(Dev、QA、Prod)上有 Tx 日志，但也许我们可以在开发者机器上不用它们.

My scenario: We need Tx logs on servers (Dev, QA, Prod), but maybe we can do without them on developer machines.

推荐答案

在任何情况下，您都离不开 SQL Server 中的事务日志.引擎根本无法运行.

You can't do without transaction logs in SQL Server, under any circumstances. The engine simply won't function.

您可以在开发机器上将恢复模式设置为 SIMPLE - 这将防止在 tran 日志备份未完成时事务日志膨胀.

You CAN set your recovery model to SIMPLE on your dev machines - that will prevent transaction log bloating when tran log backups aren't done.

ALTER DATABASE MyDB SET RECOVERY SIMPLE;

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