Disable Transaction Log

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

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


Answer

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

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;

Leave a Reply

Your email address will not be published. Required fields are marked *