Comprehensive data protection for all workloads
Post Reply
d3nz
Expert
Posts: 127
Liked: 14 times
Joined: Mar 20, 2018 12:47 pm
Contact:

The following SQL database patches are missed: TFS412962

Post by d3nz »

Hello,
After successful updating VBR from 11a P20220302 to 11a P20230227 by ZIP service Veeam Backup Service doesn't start with error:
The following SQL database patches are missed: TFS412962. (Veeam.Backup.DBCreator.DatabaseException)
DB of VBR located at external MS SQL Server v15.0.2000.5 Standard Edition.
d3nz
Expert
Posts: 127
Liked: 14 times
Joined: Mar 20, 2018 12:47 pm
Contact:

Re: The following SQL database patches are missed: TFS412962

Post by d3nz »

Why my previous topic was deleted?
d3nz
Expert
Posts: 127
Liked: 14 times
Joined: Mar 20, 2018 12:47 pm
Contact:

Re: The following SQL database patches are missed: TFS412962

Post by d3nz »

Updating MS SQL Server to v15.0.4312.2 doesn't resolve the issue.
What's the "TFS412962"? Google don't know about it almost nothing...
Gostev
Chief Product Officer
Posts: 31347
Liked: 6597 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: The following SQL database patches are missed: TFS412962

Post by Gostev »

d3nz wrote: May 11, 2023 11:04 am Why my previous topic was deleted?
Topics can only ever be deleted if they outright violate the forum rules shown in red font when you click New Topic.
Please review the rules carefully and follow them closely with your future contributions on this community.
Thank you for understanding!
d3nz
Expert
Posts: 127
Liked: 14 times
Joined: Mar 20, 2018 12:47 pm
Contact:

Re: The following SQL database patches are missed: TFS412962

Post by d3nz »

Solution is executing next SQL Query for VBR DB:

REMOVED

#MOD: SQL query has been removed. Please note that configuration database modifications should only be done when instructed by a Veeam customer support and only in the particular environment. Executing random SQL queries on your own may lead to unpredictable results and render your backup infrastructure unsupported. As such, please don't share solutions for your specific situations publicly.
Mildur
Product Manager
Posts: 8261
Liked: 2149 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: The following SQL database patches are missed: TFS412962

Post by Mildur »

Hi d3nz

I'm glad you found a solution but I had to remove the SQL query from the forum.
Please don't post SQL queries provided by our support team in public places.
It is not supported to run them without guidance of our support team.

Best,
Fabian
Product Management Analyst @ Veeam Software
d3nz
Expert
Posts: 127
Liked: 14 times
Joined: Mar 20, 2018 12:47 pm
Contact:

Re: The following SQL database patches are missed: TFS412962

Post by d3nz »

Does it make sense to wait for proper update or use this fix for every installation while updating?
Mildur
Product Manager
Posts: 8261
Liked: 2149 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: The following SQL database patches are missed: TFS412962

Post by Mildur »

Product Management cannot decide if it's safe to use such SQL queries or not. Best to ask your support engineer.

If the support engineer in your case suggest to run it for every installation you have, then you can do that. But I imagine he may want to see the database or logs for every installation to make sure the fix still applies there and won't have unwanted side effects.

Thank you,
Fabian
Product Management Analyst @ Veeam Software
Gostev
Chief Product Officer
Posts: 31347
Liked: 6597 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: The following SQL database patches are missed: TFS412962

Post by Gostev »

Indeed, while most solutions from support are fine to share publicly with the community, direct configuration database edits are just too dangerous. People tend to randomly try everything they can find on the Internet and this can really mess up the installation without you even knowing (and without any way to roll back).
d3nz
Expert
Posts: 127
Liked: 14 times
Joined: Mar 20, 2018 12:47 pm
Contact:

Re: The following SQL database patches are missed: TFS412962

Post by d3nz »

As for technical support, this is an empty conversation, because your company unilaterally terminated the support we bought without compensation.
The only question is that this is a clear flaw in the update and will it be fixed?
Gostev
Chief Product Officer
Posts: 31347
Liked: 6597 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: The following SQL database patches are missed: TFS412962

Post by Gostev »

If this was a "clear flaw in the update", there would have been a multi-page topic from other users in less than 24 hours after its release, as it always happens with any real significant bugs. However, the fact that you're the first to bring this up in over 2 months indicates the issue is rather environment-specific.
d3nz
Expert
Posts: 127
Liked: 14 times
Joined: Mar 20, 2018 12:47 pm
Contact:

Re: The following SQL database patches are missed: TFS412962

Post by d3nz »

Gostev,
I remember 9.5 U4b where wasn't available button Delete at VMs page of Self-Service Portal of VBEM for half year till we created SR to Tech Sup which created patch (;
LoL
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 70 guests