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

Can SQL Backup 4.5 restore backups made with 3.2?

MvdVMvdV Posts: 8
edited July 10, 2006 10:27PM in SQL Backup Previous Versions
It seems like not because I get an error message saying "Failed to read file list from backup file".

Comments

  • peteypetey Posts: 2,358 New member
    Yes, it is possible to restore a backup created with SQL Backup 3.2. Could you pls run a couple of tests on that file and check if the results returned are correct? Thanks.

    master..sqlbackup '-sql "RESTORE SQBHEADERONLY FROM DISK = [<file name>]" '

    master..sqlbackup '-sql "RESTORE HEADERONLY FROM DISK = [<file name>]" '

    master..sqlbackup '-sql "RESTORE VERIFYONLY FROM DISK = [<file name>]" '

    master..sqlbackup '-sql "RESTORE FILELISTONLY FROM DISK = [<file name>]" '
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.