Standalone backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)
Post Reply
jeffp
Novice
Posts: 3
Liked: 1 time
Joined: Jan 17, 2017 2:13 pm
Contact:

SQL Server Error with Veeam Endpoint Backup on Server 2012R2

Post by jeffp »

I am getting this error on a new error on a server that was previously working:

Code: Select all

Error: Microsoft SQL server hosting the configuration database is currently unavailable. Possible reasons are heavy load, networking issue, server reboot, or hot backup. Please wait, and try again later. Error information: The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_OIBs_OIBs". The conflict occurred in database "VeeamBackup", table "dbo.Backup.Model.OIBs", column 'link_id'. The statement has been terminated.
Job has been stopped with failures. Name: [Backup Job SITCDBAPP], JobId: [b07d9f98-c772-460e-a7c3-e47b4a455b94] Error: Microsoft SQL server hosting the configuration database is currently unavailable. Possible reasons are heavy load, networking issue, server reboot, or hot backup. Please wait, and try again later. Error information: The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_OIBs_OIBs". The conflict occurred in database "VeeamBackup", table "dbo.Backup.Model.OIBs", col
Any Ideas?

I tried KB2067 but, there were no scrips running for the solution presented to act upon.
Dima P.
Product Manager
Posts: 14396
Liked: 1568 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: SQL Server Error with Veeam Endpoint Backup on Server 20

Post by Dima P. »

Hello jeffp,

Kindly open a support case via Control Panel > Support > Technical Support and share the case ID. Thank you.
jeffp
Novice
Posts: 3
Liked: 1 time
Joined: Jan 17, 2017 2:13 pm
Contact:

Re: SQL Server Error with Veeam Endpoint Backup on Server 20

Post by jeffp » 1 person likes this post

Case number is 02111125.
BGA-Robert
Service Provider
Posts: 60
Liked: 8 times
Joined: Feb 03, 2016 5:06 pm
Full Name: Robert Wakefield
Contact:

Re: SQL Server Error with Veeam Endpoint Backup on Server 20

Post by BGA-Robert »

Your Veeam server may be under provisioned. You may need to look at max number of Veeam tasks vs Procs and RAM. Veeam needs something like 2GB RAM for each proc and then you need to configure the max number of tasks per proxy, repro, etc. Assume Veeam will need 1 proc per task. Tasks meaning hard drives being backed up concurrently.

But I've found that you may need to provision resources for the SQL server, in addition to the above. So, for example, if you feel like 8 procs and 16GB RAM satisfies your Veeam config, add another proc for the SQL server and a little more RAM.
Dima P.
Product Manager
Posts: 14396
Liked: 1568 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: SQL Server Error with Veeam Endpoint Backup on Server 20

Post by Dima P. »

Robert,
Tasks meaning hard drives being backed up concurrently.
For agent backup jobs targeting Veeam backup repository we count one agent as one task.
Post Reply

Who is online

Users browsing this forum: No registered users and 34 guests