October 27, 2009 at 6:50 am
I have a job that backups database "IBM_3479" and then restores that backup in other server as "IBM_3479_old". Now i got the below error and i also saw that the restore was done successfully but according to me i understand that the backup file "IBM_3479" might be corrupted, so can i go ahead and delete that backup file so that again when the process takes place i have a new set of backup file. please let me know if i am going wrong somewhere or what you all think about this error.
this is the error log :-----------------------
Executing the query "backup database IBM_3479 to disk = '\\\\ibm-stg-nas\\back\\IBM_3479_old.bak' with init, copy_only" failed with the following error: "The backup data at the end of "\\\\ibm-stg-nas\\back\\IBM_3479_old.bak" is incorrectly formatted. Backup sets on the media might be damaged and unusable. To determine the backup sets on the media, use RESTORE HEADERONLY. To determine the usability of the backup sets, run RESTORE VERIFYONLY. If all of the backup sets are incomplete, reformat the media using BACKUP WITH FORMAT, which destroys all the backup sets.
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
October 27, 2009 at 6:56 am
It appears that you are making multiple backups to the same file. While you can do this, and you can store multiple backups in one file, if something happens, you lose all your backups.
I would recommend backing up to a new file every day. That way if you have an issue, you still have the old backups. If you need to back up to the same file each day, and are copying the old one to tape or some other media, you can add the WITH INIT clause to your backup to create a new file each time.
October 27, 2009 at 7:12 am
actually this is a job that runs every day i.e backup and restore to a new server. so i cannot create a new backup set every day. actually the new backup that occurs every day replaces/overwrites the old backup. so any idea.....
October 27, 2009 at 7:23 am
You can delete the file, and then run a full backup to test, but it should work.
There are plenty of people that create a new file name every day and then restore that to another server. It's not hard to script, and there are even some scripts on this site that will help if you look around.
October 27, 2009 at 7:41 am
thanks will let you know if that works.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply