Merge Duplicate bak files that are created during conversion

LStrait

Does anyone know of a way to merge the many bak files that are created from converting one SQL backup file to MS SQL backup format into one bak file instead of many besides running the backups single threaded.

My company would like to run the backups multi-threaded but need to end up with one bak file after the conversion to give to our clients

Brian Donahue

Hello,

Multithreaded, single-file backups are a feature specific to the SQL Backup software and there is no equivilent feature in native SQL Server backup. This is why a SQL Backup multithreaded backup is converted to a collection of .BAK files that have to be restored in one go by specifying multiple DISK parameters in the restore command.