SQL Server Error with Veeam Endpoint Backup on Server 2012R2

Backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)

SQL Server Error with Veeam Endpoint Backup on Server 2012R2

Veeam Logoby jeffp » Mon Mar 27, 2017 1:48 pm

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.
jeffp
Novice
 
Posts: 3
Liked: 1 time
Joined: Tue Jan 17, 2017 2:13 pm

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

Veeam Logoby Dima P. » Mon Mar 27, 2017 8:09 pm

Hello jeffp,

Kindly open a support case via Control Panel > Support > Technical Support and share the case ID. Thank you.
Dima P.
Veeam Software
 
Posts: 6391
Liked: 449 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

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

Veeam Logoby jeffp » Mon Mar 27, 2017 8:29 pm 1 person likes this post

Case number is 02111125.
jeffp
Novice
 
Posts: 3
Liked: 1 time
Joined: Tue Jan 17, 2017 2:13 pm

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

Veeam Logoby BGA-Robert » Mon Apr 03, 2017 5:09 pm

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.
BGA-Robert
Service Provider
 
Posts: 23
Liked: 3 times
Joined: Wed Feb 03, 2016 5:06 pm
Full Name: Robert Wakefield

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

Veeam Logoby Dima P. » Tue Apr 04, 2017 10:40 am

Robert,

Tasks meaning hard drives being backed up concurrently.

For agent backup jobs targeting Veeam backup repository we count one agent as one task.
Dima P.
Veeam Software
 
Posts: 6391
Liked: 449 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov


Return to Veeam Agent for Windows



Who is online

Users browsing this forum: No registered users and 9 guests