Host-based backup of VMware vSphere VMs.
Post Reply
mtav
Influencer
Posts: 14
Liked: never
Joined: Jan 05, 2023 1:24 pm
Contact:

Job marked as successful - but SQL Server Backup failed

Post by mtav »

Hello,

on a backup to disk job that is marked as successful i found this entry in the logfile:

22.04.2025 22:24:41 :: Transaction logs backup will not be possible due to insufficient permissions to update backupset for SQL instance : connection error

I understand its because the user under which the backup runs cannot access the SQL Server DB as its unknown in the SQL Server.

But is it normal that the whole backup job is marked as successful anyway? The job is set to require successful Application Aware Processing.
When i right click on the backup i cannot select "Restore Application Items.", so it seems to me i wouldnt be able to restore the SQL Server on this VM.
PetrM
Veeam Software
Posts: 3820
Liked: 643 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: Job marked as successful - but SQL Server Backup failed

Post by PetrM »

Hello,

I'm not sure that this behavior is correct, I don’t think the job should report success in this case. Furthermore, I don’t understand why you cannot restore application items, restoring in Veeam Explorer for SQL Server must be available for image-level backups (without point-in-time restore). I need some time to discuss this behavior with the team.

Could you please open a support case and provide the support case ID? I'm curious why you cannot select "Restore Application Items". Have you checked the permissions for the SQL Server outlined on this page?

Thanks!
Post Reply

Who is online

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