The old command “DUMP TRANSACTION [db_name] WITH NO_LOG;” no longer works in SQL 2008 to dump the transaction log. Instead I found a GUI work around. I don’t like it as much but it works for now until I find something better. If I do, I’m not a DBA anyway. 1. Open SQL Management Studio … Continue reading How to dump transaction log in MSSQL 2008