What are the challenges you face when working across database platforms? Take the survey
Options

Diff backup fails

rdaltonrdalton Posts: 36
edited October 27, 2005 2:11PM in SQL Backup Previous Versions
I tried to restore a diff backup and errored out. (It told me it wasn't part of the backup set.) I was doing the restore through the GUI. I'm on ver 3.1.0.1.

I converted the file from the .sqb to the .bak and the file still wouldn't restore.

Is there a way to verify the backup file? In native sqlserver, you have the option to verify backup file. Is there a switch to do the same using your tool?

After having one fail, it makes me very nervous not to be able to confim the backup format.

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Yes, in Query Analyzer, use

    sqlbackup '-SQL "RESTORE HEADERONLY FROM DISK = [xxx]

    or

    sqlbackup '-SQL "RESTORE SQBHEADERONLY FROM DISK = [xxx]

    Ensure that all files in the backup set you are trying to restore have the same details.
    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.