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

Advertisements

Thinking of getting a bigger pool?

SQL Server 2014 introduced us to a number of great new features, one that’s often overlooked but can quite easily improve the performance of read-heavy OLTP workloads, especially on resource constrained hardware, is Buffer Pool Extensions (BPE).

Continue reading