Backup of enterprise applications (Microsoft stack, IBM Db2, MongoDB, Oracle, PostgreSQL, SAP)
Post Reply
mkaaden
Enthusiast
Posts: 34
Liked: 3 times
Joined: Dec 11, 2017 12:35 pm
Contact:

Cannot upgrade backup chain format due to SQL logs

Post by mkaaden »

I have a separate job for SQL backups which also runs SQL logs every hour.
Only this job won't allow an upgrade of the backup chan format with the following error:
"Failed to upgrade backup B-XXX-SQL Error: Unable to upgrade a backup chain because it is currently in use by a backup copy or a transaction log backup copy job."

Then I tried to upgrade the backup chain formot on the Backup Copy which is ONE job with all the backup jobs attached.
Again error:
"Failed to upgrade backup C-XXX-YYY\B-ZZZ-Oracle, C-XXX-YYY\B-ZZZ-AD, C-XXX-YYY\B-ZZZ-SQL, C-XXX-YYY\B-ZZZ-Templates, C-XXX-YYY\B-ZZZ-xxxxx, CC-XXX-YYY\B-ZZZ-Files, C-XXX-YYY\\B-ZZZ-etc Error: Unable to upgrade a backup chain because it is currently in use by an image-level or a transaction log backup job"

Now what ?
PetrM
Veeam Software
Posts: 3812
Liked: 643 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: Cannot upgrade backup chain format due to SQL logs

Post by PetrM »

Hello,

As stated on this page:
Before upgrading the backup chain format of backup copy backups, upgrade the backup chain format of source backups first.
AND
You must disable log backup jobs manually before changing the format.
Please have a look at this section of our user guide to disable log backup.

Thanks!
mkaaden
Enthusiast
Posts: 34
Liked: 3 times
Joined: Dec 11, 2017 12:35 pm
Contact:

Re: Cannot upgrade backup chain format due to SQL logs

Post by mkaaden » 1 person likes this post

Thanks, disabling Log backup in the job did the trick.

II still had to enable the Job before I could do the backup chain format upgrade, which automatically disables the job again.
Then I could upgrade the format on the copy job.

After that I enabled Log backup and enable the job.
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests