What’s New in Transaction Management
Not much has really changed in SQL Server 2008 related to transactions, transaction logging, and transaction management. About the only real change is the removal of the WITH TRUNCATE_ONLY
and WITH NO_LOG
options from the BACKUP LOG
command. These options are no longer available in SQL Server 2008 to prune the transaction log. The alternative is to switch the database to simple recovery model.
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.