Can you use sqb2mtf if you have split the backup files?

RML51RML51 Posts: 21
edited October 31, 2005 9:41AM in SQL Backup Previous Versions
If you split the SQL Backup into two output files, can you use the "sqb2mtf" to get a useable, native, backup file?

e.g. If I have xxxx_backup_1.sqb and xxxx_backup_2.sqb can I use the sqb2mtf command to obtain a usable xxxx_backup.bak file? If so, how?
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    edited October 31, 2005 10:35AM
    Use sqb2mtf to convert each of the two sqb files to native backup files, then use the RESTORE command with two DISK parameters to restore the backup e.g.

    sqb2mtf <path>\xxxx_backup_1.sqb <path>\xxxx_backup_1.bak
    sqb2mtf <path>\xxxx_backup_2.sqb <path>\xxxx_backup_2.bak

    RESTORE DATABASE xxxx FROM DISK = '<path>\xxxx_backup_1.bak', DISK = '<path>\xxxx_backup_2.bak'
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • RML51RML51 Posts: 21
    Thank you, Peter. That worked!
    · Share on Twitter
Sign In or Register to comment.