• Jeffrey Williams 3188 (5/16/2013)


    You will only see value in striping a backup when you have multiple drives available - and separate IO paths to those drives. Striping a backup to the same location could actually slow your backups down.

    That's not true when using native compression. Each file backs up with a single thread, so to make use of multi-threading for the compression, you need multiple backup files. The single-threaded nature of backup compression is almost always the bottleneck in modern servers, so even if writing to a single LUN/volume there are serious performance gains from multiple files.

    I'd recommend looking at Ola's excellent backup scripts, which have a parameter for splitting to multiple files:

    http://ola.hallengren.com/sql-server-backup.html