Options

SQL Backup to MTF Converter Problem

cbkowitzcbkowitz Posts: 4
edited July 24, 2007 6:32AM in SQL Backup Previous Versions
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?
Thanks,

Chris Kowitz
· Share on Twitter

Comments

  • Options
    HJoyceHJoyce Posts: 186
    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'
    Helen Joyce
    SQL Backup Project Manager
    Red Gate Software
    · Share on Twitter
  • Options
    cbkowitzcbkowitz Posts: 4
    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.
    Thanks,

    Chris Kowitz
    · Share on Twitter
Sign In or Register to comment.