Comprehensive data protection for all workloads
bjesteadt
Influencer
Posts: 13
Liked: 2 times
Joined: Aug 13, 2018 2:53 pm
Full Name: Brian Jesteadt
Contact:

Re: SQL Backups and 9.5U3

Post by bjesteadt » Aug 21, 2018 1:05 pm

I have already applied the workaround, but with no success.

As I mentioned, I have no access to the SQL databases or instance to modify the permissions.

Gostev
SVP, Product Management
Posts: 24643
Liked: 3470 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL Backups and 9.5U3

Post by Gostev » Aug 21, 2018 1:10 pm

The patch provided in the KB article does solve the issue, so please work with our technical support to verify that you have applied it correctly.
If your engineer can't find the reason why it does not work for you, he will escalate to a higher support tier for further investigation.

unsichtbarre
Expert
Posts: 118
Liked: 21 times
Joined: Mar 08, 2010 4:05 pm
Full Name: John Borhek
Contact:

[MERGED] Highly irresponsible - 9.5.0.1922 (Update 3a)

Post by unsichtbarre » Oct 04, 2018 3:22 pm

Hi all-
I am a big fan of Veeam but right now I couldn't be more disappointed. Veeam Backup & Replication 9.5.0.1922 (Update 3a) is completely unacceptable due to the way it changes the required SQL Permissions required for Application Aware Image Processing. There are two KB articles (KB2447 and KB2689) and a long thread here on the communities regarding the issues and fix(es) possible, but that's not actually the problem.

My company is a Veeam Service provider. That means we don't necessarily have access to our customers AD or SQL instances. The problem is that, without asking or notifying, Veeam has now required that I contact each and every customer and request a support session where we will have to:

A. Modify AD and/or Group Policy
B. Run queries against their SQL Server instances
C. Connect to their Veeam proxy instance to replace files installed by the update

Not only is this intrusive, but administrators tend to be highly protective of their AD and SQL Databases. Just the fact that I need to ask for 'local' access to resources (whether that be the Proxy or SQL database) is enough to raise questions on the part of customers who simply want their backup and DR solution to function silently.

We need a hotfix that will allow automatic update of our Veeam Proxies remotely, and we need it ASAP!

At the moment, Veeam no longer just works!
-The Invisible Admin-
http://www.johnborhek.com

Gostev
SVP, Product Management
Posts: 24643
Liked: 3470 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL Backups and 9.5U3

Post by Gostev » Oct 04, 2018 11:46 pm

Hello, you should contact support for any hot fixes, or if you need help deploying them. Thanks!

unsichtbarre
Expert
Posts: 118
Liked: 21 times
Joined: Mar 08, 2010 4:05 pm
Full Name: John Borhek
Contact:

Re: SQL Backups and 9.5U3

Post by unsichtbarre » Oct 05, 2018 2:07 pm

Gostev,

#1, I did not add my post to this thread (it was MERGED) because it is not about the fix - it is about the irresponsible nature which Veeam allowed 3a intio customers hands. Especially Service Providers.
#2. I have sought a hotfix via ticket 03199036 - with no ETA at this time
-The Invisible Admin-
http://www.johnborhek.com

Gostev
SVP, Product Management
Posts: 24643
Liked: 3470 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL Backups and 9.5U3

Post by Gostev » Oct 05, 2018 11:24 pm

Hello, your post was merged into this thread to prevent duplicate discussions, because the topic of "the irresponsible nature which Veeam allowed 3a into customers hands" has already been discussed here earlier. And I too shared my own frustration about this earlier in this thread.

Regnor
Service Provider
Posts: 317
Liked: 62 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

Re: SQL Backups and 9.5U3

Post by Regnor » Nov 06, 2018 8:17 am

Regarding the Hotfix; https://www.veeam.com/kb2689

I've just noticed that the Veeam console distinguishes between U3a and U3a+Hotfix. Connection will only work to one of Veeam instance and the other will try to update the console.
Also when installing Enterprise Manager on U3a+Hotfix, the setup installed U3a and reverted the hotfix.

Are those known issues?

foggy
Veeam Software
Posts: 18158
Liked: 1542 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Backups and 9.5U3

Post by foggy » Nov 07, 2018 12:14 pm

Connection will only work to one of Veeam instance and the other will try to update the console.
I would expect this, since Veeam B&R tries to automatically update all its remote components.
Also when installing Enterprise Manager on U3a+Hotfix, the setup installed U3a and reverted the hotfix.
Seems like setup rewrites some of the hotfix files. I believe you can install hotfix once again after that.

Regnor
Service Provider
Posts: 317
Liked: 62 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

Re: SQL Backups and 9.5U3

Post by Regnor » Nov 10, 2018 6:38 am 1 person likes this post

I wasn't sure about that as I thought the hotfix changes only the SQL behaviour.
I have now installed the hotfix on both installations so the console works on both.

foggy
Veeam Software
Posts: 18158
Liked: 1542 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Backups and 9.5U3

Post by foggy » Nov 12, 2018 3:00 pm

Hotfix replaces a bunch of Veeam B&R files that are used for other tasks as well. For proper operation, all components need to be on par in terms of their build numbers.

jrbaumann
Influencer
Posts: 23
Liked: 2 times
Joined: Oct 18, 2018 12:37 pm
Full Name: Jeff Baumann
Contact:

Re: SQL Backups and 9.5U3

Post by jrbaumann » Nov 12, 2018 3:28 pm

Just to verify, i should backup the files listed in KB2689 on the backup server AND all 9 of my proxy servers then replace the files with the files in the hotfix on each of them?


JB

foggy
Veeam Software
Posts: 18158
Liked: 1542 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Backups and 9.5U3

Post by foggy » Nov 12, 2018 3:32 pm 1 person likes this post

...backup server AND all 9 of my proxy servers...
Guest interaction proxies, not backup proxies.

tom_nl
Influencer
Posts: 17
Liked: 1 time
Joined: Nov 02, 2018 9:13 am
Contact:

Re: SQL Backups and 9.5U3

Post by tom_nl » Nov 21, 2018 9:55 am

Will the hotfix be included in update 4?

wishr
Veeam Software
Posts: 1103
Liked: 111 times
Joined: Aug 07, 2018 3:11 pm
Full Name: Fedor Maslov
Contact:

Re: SQL Backups and 9.5U3

Post by wishr » Nov 21, 2018 11:21 am

Hi Tom,

Sure thing, the hotfix will be a part of the B&R U4 release. Just in general all the public hotfixes are usually included into nearest releases as well as in further ones.

Thanks,
Fedor

quintero
Novice
Posts: 3
Liked: never
Joined: Jul 17, 2018 8:50 am
Full Name: Gareth
Contact:

[MERGED] SQL Backupset Instance

Post by quintero » Dec 20, 2018 11:14 am

Hi,

I have the following issue when backing up VMs with SQL servers on them:

[TDB]Unable to update SQL backupset for instance : Code = 0x80040e09

I am not the database admin so am not familiar enough with SQL. I have seen a blog post stating that the user with the relevant permissions should be added to the 'logon as batch user' and then as sysadmin on the SQL server itself but was wondering if there was any other way that this issue could be rectified

Many thanks!

DGrinev
Veeam Software
Posts: 1727
Liked: 220 times
Joined: Dec 01, 2016 3:49 pm
Full Name: Dmitry Grinev
Location: St.Petersburg
Contact:

Re: SQL Backupset Instance

Post by DGrinev » Dec 20, 2018 11:24 am

Hey Gareth,

You will find a plenty of useful information about the issue in this big thread.
Please review the KB article mentioned in the posts above, it should solve the issue. Thanks!

mike.r
Enthusiast
Posts: 33
Liked: 3 times
Joined: Jun 03, 2015 7:00 am
Contact:

Re: SQL Backups and 9.5U3

Post by mike.r » Jan 08, 2019 10:31 am

Hi,

I have installed the Hotfix and it works as described.
SQL Database backup is now successful again and the error message is now an "info message".
So far so good.
But what does the message "Transaction logs backup will not be possible..." mean exactly ?
Is the transaction log of the SQL Database backuped or not ?
And did Veeam truncate the transaction log (just as it did before Update 3a) or not ?

Gostev
SVP, Product Management
Posts: 24643
Liked: 3470 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL Backups and 9.5U3

Post by Gostev » Jan 09, 2019 2:48 am

This talks about transaction log backup functionality specifically
https://helpcenter.veeam.com/docs/backu ... tml?ver=95

Log truncation functionality will not be affected.

hwelvaar
Novice
Posts: 7
Liked: never
Joined: Feb 08, 2018 1:58 pm
Contact:

Re: SQL Backups and 9.5U3

Post by hwelvaar » Mar 21, 2019 2:54 pm

Is this fixed in 9.5 Update4 ?
(or is the hotfix for U3 integrated in U4) ?

wishr
Veeam Software
Posts: 1103
Liked: 111 times
Joined: Aug 07, 2018 3:11 pm
Full Name: Fedor Maslov
Contact:

Re: SQL Backups and 9.5U3

Post by wishr » Mar 21, 2019 4:00 pm

Hi Hwelvaar,

As I have already mentioned on the previous page, the hotfix is included in the U4 release.

Regards,
Fedor

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 19 guests