SQL Backups and 9.5U3

Availability for the Always-On Enterprise

Re: SQL Backups and 9.5U3

Veeam Logoby foggy » Wed Jul 11, 2018 11:47 am 1 person likes this post

ae_group_ag wrote:We have the same issue but with Windows Server 2003. I added our veeam service user to the sysadmin role but this doesn't solved it.
The error message is "Logon failure: the user has not been granted the requested logon type at this computer".

Logon as batch job right is still required even if the account has sysadmin role.
foggy
Veeam Software
 
Posts: 16299
Liked: 1302 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Backups and 9.5U3

Veeam Logoby hansvh » Wed Jul 11, 2018 12:45 pm

As far as I understand, for the issue with "Unable to update SQL backupset" error, the immediate fix is db_datawriter permission on msdb database for the account you use for SQL processing.

Hmmm. This does not seem to work. I've got a replication job running of a SQL server with this issue. Gave the Veeam user which runs the job the db_datawriter permission on the SQL server by running this query:
Code: Select all
use msdb
go

alter role db_datawriter add member [username];
go

Job still finishes with same warning. Am I missing something?
hansvh
Influencer
 
Posts: 10
Liked: 1 time
Joined: Tue Feb 26, 2013 11:24 am
Full Name: Hans

Re: SQL Backups and 9.5U3

Veeam Logoby Gostev » Wed Jul 11, 2018 12:52 pm

Please use test SQL queries from the last post on the previous page to troubleshoot this (or open a support case for assistance).
Gostev
Veeam Software
 
Posts: 22401
Liked: 2676 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: SQL Backups and 9.5U3

Veeam Logoby hansvh » Wed Jul 11, 2018 1:18 pm 1 person likes this post

hansvh wrote:Job still finishes with same warning. Am I missing something?

I indeed was missing something :oops: . The useraccount that runs the backups has local admin rights on the database server as well as SQL sysadmin rights on the database itself. Completely forgot about another SQL server instance running on the same server (sigh). Gave the Veeam user sysadmin rights on that instance as well which solved my problem!
hansvh
Influencer
 
Posts: 10
Liked: 1 time
Joined: Tue Feb 26, 2013 11:24 am
Full Name: Hans

Re: SQL Backups and 9.5U3

Veeam Logoby melliott7 » Wed Jul 11, 2018 1:43 pm

Hi Gostev,

I ran the first 2 test quires and It had the correct output on those. However when I go to run the third query it gave me this message below.

!!Here is the query I copied from your post!!

update [msdb].[dbo].[backupset]
set name = 'test'
where backup_set_id = <any_backup_set_id>


!!Here is the error message I recieved!!!

Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '<'.

Let me know what you think when you get a chance.

Thanks,
melliott7
Novice
 
Posts: 3
Liked: never
Joined: Mon Jul 09, 2018 12:30 pm
Full Name: Marcus Elliott

Re: SQL Backups and 9.5U3

Veeam Logoby foggy » Wed Jul 11, 2018 1:52 pm

You should specify a valid ID from msdb.dbo.backupset table here. You can take any from the select backup_set_id from msdb.dbo.backupset output.
Also, please ensure you're executing it under the user that is specified in the job and on the same instance you're getting the warning for.
foggy
Veeam Software
 
Posts: 16299
Liked: 1302 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Backups and 9.5U3

Veeam Logoby Gostev » Wed Jul 11, 2018 9:25 pm

All, we have created a hotfix that does two things:

1. After failing to logon as a batch job, the job will immediately retry using interactive logon (pre-U3a way) before failing completely.

2. Warning about backupset update failure was changed to info event which additionally explains the issue in better details:
Transaction logs backup will not be possible due to insufficient permissions to update backupset for SQL instance: %SQLInstance%

Adjusting account's security rights and permissions on msdb according to the updated system requirements remains the preferred solution for obvious reasons, however we still decided to provide the hotfix for situation when adjusting account settings is not possible. The hotfix is available through our support.
Gostev
Veeam Software
 
Posts: 22401
Liked: 2676 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: SQL Backups and 9.5U3

Veeam Logoby igelm » Thu Jul 12, 2018 11:21 am

Hello,
Where exactly can I download this hotfix?
igelm
Lurker
 
Posts: 1
Liked: never
Joined: Thu Jul 12, 2018 4:58 am
Full Name: Marcin Igel

Re: SQL Backups and 9.5U3

Veeam Logoby foggy » Thu Jul 12, 2018 11:27 am

Hi Marcin, please contact support to obtain it.
foggy
Veeam Software
 
Posts: 16299
Liked: 1302 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Backups and 9.5U3

Veeam Logoby willjohnson » Thu Jul 12, 2018 11:29 am

We've asked twice but still haven't received the hotfix...
willjohnson
Novice
 
Posts: 4
Liked: never
Joined: Wed Jul 11, 2018 8:02 am

Re: SQL Backups and 9.5U3

Veeam Logoby foggy » Thu Jul 12, 2018 11:33 am

Please ask to escalate the case, chances are not everyone on the first line is yet aware, since the hot fix was just posted. T3 is certainly aware.
foggy
Veeam Software
 
Posts: 16299
Liked: 1302 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Backups and 9.5U3

Veeam Logoby foggy » Thu Jul 12, 2018 4:42 pm 1 person likes this post

Now all the support tiers are informed, so no more need to escalate the case to get the hotfix. Thanks!
foggy
Veeam Software
 
Posts: 16299
Liked: 1302 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Backups and 9.5U3

Veeam Logoby fcompaired » Thu Jul 12, 2018 7:26 pm

I'm experiencing same issue after upgrading. I opened a case and was sent to this forum thread. :?:
fcompaired
Novice
 
Posts: 6
Liked: 1 time
Joined: Mon Nov 02, 2015 4:02 pm
Full Name: Federico Compaired

Re: SQL Backups and 9.5U3

Veeam Logoby fcompaired » Thu Jul 12, 2018 7:43 pm 1 person likes this post

The error I started seeing in alll SQL transaction log sessions is:
Unable to truncate Microsoft SQL Server transaction logs. Details: Failed to call RPC function 'Vss.TruncateSqlLogs': Error code: 0x80004005. Failed to invoke func [TruncateSqlLogs]: Unspecified error. Failed to process 'TruncateSQLLog' command. Failed to logon user [domain\user]. Win32 error:Logon failure: the user has not been granted the requested logon type at this computer. Code: 1385

Veeam support mentioned the setting 'Log on as batch job'

In our scenario we use a domain service account that has sysadmin role in all SQL instances. What I just did was granting 'Log on as batch job' permission to the service account in AD and tested running a backup job restarting the Log session. It has worked for this 1 job. I will keep checking all the other jobs.
fcompaired
Novice
 
Posts: 6
Liked: 1 time
Joined: Mon Nov 02, 2015 4:02 pm
Full Name: Federico Compaired

Re: SQL Backups and 9.5U3

Veeam Logoby melliott7 » Fri Jul 13, 2018 2:10 pm

Hi Foggy and Gostev,

Thanks for the help with the 3 SQL Queries. I was able to run the third query and that completed with out a hitch so all three check out okay. I Ran the quires with the same account that is used for the backups and in SQL Server Management Studio I signed in using windows authentication with the same account. I also double checked SQL Server configuration manager to make sure there wasn't any other instances running that I didn't know about and it looks like there is only one (MSSQLSERVER, SQL Server Browser, and SQL Server Agent). Im still getting that warning message after several days.

let me know what you guys think when you get a chance.

Thanks,
melliott7
Novice
 
Posts: 3
Liked: never
Joined: Mon Jul 09, 2018 12:30 pm
Full Name: Marcus Elliott

PreviousNext

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], superbeta and 54 guests