Using SQL Backup File Converter output into Single BAK file

james_wise

Hello,

I've tried to use SQL Backup File Converter (SQBConverter.exe) command line to convert a database_backup.sqb file. The output was producing multiple MTF files such as below. How can you convert the SQB to produce only single BAK file?

-database_backup_00.bak 
-database_backup_01.bak 
-database_backup_02.bak 
-database_backup_03.bak 
-database_backup_04.bak 
..... 
-database_backup_20.bak

Thanks.

Dan B

Hi James,

The backup file is converted into multiple .baks for each thread used to run the backup. So if the backup runs with 16 threads it will create 16 .bak files for example. You can still restore these using one backup command following the below syntax

RESTORE DATABASE ReportServerSplitCopy FROM 
 DISK = 'D:\DBBackups\ReportServer\ReportServer_Split1.bak'
,DISK = 'D:\DBBackups\ReportServer\ReportServer_Split2.bak'
,DISK = 'D:\DBBackups\ReportServer\ReportServer_Split3.bak'

Please do let me know if you have any further questions.