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

Diff backup fails

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.
rdalton
0

Comments

1 comment

Sort by
  • petey
    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.
    petey
    0

Add comment

Please sign in to leave a comment.