How can we help you today? How can we help you today?

Using SQL Backup File Converter output into Single BAK file

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.

James Corteciano
0

Comments

1 comment

Sort by
  • 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.
    Dan B
    0

Add comment

Please sign in to leave a comment.