Diff backup fails
rdalton
Posts: 36
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.
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
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.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8