Back Up SQL Server 43%-67% Faster by Writing to Multiple Files.


Even if you’re not writing to different physical drives, you can get faster backups with Microsoft SQL Server when you back up to multiple files. Your exact numbers are going to vary based on your server and your utter inability to rub two sticks together to make fire, but let’s see how I do.

Here’s the hardware I’m using:

96-core, 768GB RAM i3en.metal AWS EC2 instance with 8 7.5TB NVMe SSDs SQL Server 2019 Developer Edition CU6 Stack Overflow 2020-06 database (about 381GB)

The i3en.metal has 8 7.5TB NVMe SSDs. The Stack Overflow database ships on 4 data files and