Standalone backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)
Post Reply
zach1008
Lurker
Posts: 2
Liked: never
Joined: Jun 08, 2015 4:32 pm
Full Name: Zach Schaffner
Contact:

Endpoint backup stopped working on Win 8.1 with a sql error

Post by zach1008 » Jul 30, 2015 2:38 pm

I have been working with Endpoint backup and after a few days of things running as expected I started getting failures. The error in the job is:

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: Violation of PRIMARY KEY constraint 'PK_BObjects'. Cannot insert duplicate key in object 'dbo.BObjects'. The duplicate key value is (8c9b7dfe-36b4-4854-90af-3b75bcb7f5d1). The statement has been terminated.

I have restarted both my laptop and the server and nothing has resolved the issue. Any suggestions on this issue?

P.Tide
Product Manager
Posts: 5184
Liked: 448 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Endpoint backup stopped working on Win 8.1 with a sql er

Post by P.Tide » Jul 30, 2015 4:16 pm

Hi,
I have restarted both my laptop and the server and nothing has resolved the issue
Sorry, not sure what you mean. Do you use Endpoint on your server as well? If so, then which job gave you that error? Otherwise, how is the server related to the problem? Did you mean local SQL service?

Thank you.

zach1008
Lurker
Posts: 2
Liked: never
Joined: Jun 08, 2015 4:32 pm
Full Name: Zach Schaffner
Contact:

Re: Endpoint backup stopped working on Win 8.1 with a sql er

Post by zach1008 » Jul 30, 2015 4:18 pm

Sorry, clarification, the job is using the repository from backup and replication server but the job is on my laptop.

P.Tide
Product Manager
Posts: 5184
Liked: 448 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Endpoint backup stopped working on Win 8.1 with a sql er

Post by P.Tide » Jul 30, 2015 4:29 pm 1 person likes this post

Cannot insert duplicate key in object 'dbo.BObjects'. The duplicate key value is (8c9b7dfe-36b4-4854-90af-3b75bcb7f5d1)
Have you tried browsing your local endpoint database with Microsoft SQL server management studio and see what's stored there under that key? Maybe you will be able to identify the object referred by that id?

Anyway, I believe that you should open a case with support. If you do please post case ID here.

Thank you.

Mike Resseler
Product Manager
Posts: 5691
Liked: 599 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Endpoint backup stopped working on Win 8.1 with a sql er

Post by Mike Resseler » Jul 30, 2015 5:30 pm

Zach,

Pavel is right. Please create a support case through the support tab and post the case ID and follow-up by support here

Thanks (and thanks Pavel!)

RobC-ISGI
Lurker
Posts: 1
Liked: never
Joined: Oct 05, 2015 6:38 pm
Full Name: WWIP ITSupport
Contact:

Re: Endpoint backup stopped working on Win 8.1 with a sql er

Post by RobC-ISGI » Oct 05, 2015 7:04 pm

we can clear this up by resetting this SQL server. Please perform these following steps on the problem PC:

1. Open up RegEdit
2. Look for HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Endpoint
3. Create new DWORD value called ReCreateDatabase and assign to it 1 (decimal)
4. Start Endpoint service manually or just reboot your pc.
5. If Endpoint started successfully, delete created key.

Please note that you will have to re-run configure backup in order to set up the backup job. This will also create a brand new chain. If there are any old chains, these can still be used for restore purposes. Also, please make sure to delete that registry key once a successful backup can be confirmed.

Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests