Before You Go Down The Rabbit Hole

Effects of a Full SQL Server Transaction Log, Error 9002 and Why Understanding The Application Matters When Troubleshooting

One of my favorite topics in SQL Server is transaction log internals. When I first got started with SQL Server, I thought all I needed to do with the transaction log was to run regular log backups to make sure they don’t grow unexpectedly. Until I realized that there was more to it than I knew. […]