An ACID Trip: How SQL Server Transactions Work

In a recent consulting engagement a system administrator asked me “what’s the point of the transaction log? ” followed by “do we need it?” and “can’t we delete it?”

Continue reading


Backups having an image problem: VEEAM and SQL Log Truncation

Backing up and restoring databases from an image based recovery solution is very different to traditional SQL Server recovery methods, as I’ve found out with VEEAM Version 7.

Continue reading