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

SQL Backup to MTF Converter Problem

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?
cbkowitz
0

Comments

2 comments

Sort by
  • 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'
    HJoyce
    0
  • 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.
    cbkowitz
    0

Add comment

Please sign in to leave a comment.