Benefits of writing database backups to multiple files:
- Backup process can finish faster because it will run using multiple threads
- Better I/O throughput if you have multiple disk arrays where you can write your backup files.
Here are two methods of writing your backup to multiple files:
Using SQL Server Management Studio
Using T-SQL
BACKUP DATABASE [AdventureWorks2014] TO DISK = N'C:\SQLBackup\AdventureWorks_backupfile1.bak', DISK = N'C:\SQLBackup\AdventureWorks_backupfile2.bak', DISK = N'C:\SQLBackup\AdventureWorks_backupfile3.bak', DISK = N'C:\SQLBackup\AdventureWorks_backupfile4.bak' WITH NOFORMAT, NOINIT, NAME = N'AdventureWorks2014-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10 GO