SQL Backup to MTF Converter Problem

cbkowitz

I used the GUI version of the SQL Backup to MTF Converter. It runs with no errors, but it's creating 3 seperate .bak files. How can I get it to create one or how I can I use the 3 files to restore the database?

HJoyce

If the backup was created with multiple threads, when it's converted to native SQL Server format, it will be split into 3 files. t
You can then restore the backup from the 3 files by adding them in the Restore Database dialog in SQL Server Management Studio or in script

RESTORE DATABASE [DB1] from DISK= 'c:\backup1.bak', DISK= 'c:\backup2.bak', DISK= 'c:\backup3.bak'

cbkowitz

HJoyce wrote:

If the backup was created with multiple threads, when it's converted to native SQL Server format, it will be split into 3 files. t
You can then restore the backup from the 3 files by adding them in the Restore Database dialog in SQL Server Management Studio or in script

RESTORE DATABASE [DB1] from DISK= 'c:\backup1.bak', DISK= 'c:0\backup2.bak', DISK= 'c:\backup3.bak'

Thanks, that make sense. I appreciate your help.