Competition: What’s your favorite Redgate tool? Enter now.

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.

Tagged:

Answers

  • 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.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
Sign In or Register to comment.