Endpoint backup stopped working on Win 8.1 with a sql error

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

Endpoint backup stopped working on Win 8.1 with a sql error

Veeam Logoby zach1008 » Thu 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?
zach1008
Lurker
 
Posts: 2
Liked: never
Joined: Mon Jun 08, 2015 4:32 pm
Full Name: Zach Schaffner

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

Veeam Logoby PTide » Thu 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.
PTide
Veeam Software
 
Posts: 3019
Liked: 246 times
Joined: Tue May 19, 2015 1:46 pm

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

Veeam Logoby zach1008 » Thu 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.
zach1008
Lurker
 
Posts: 2
Liked: never
Joined: Mon Jun 08, 2015 4:32 pm
Full Name: Zach Schaffner

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

Veeam Logoby PTide » Thu 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.
PTide
Veeam Software
 
Posts: 3019
Liked: 246 times
Joined: Tue May 19, 2015 1:46 pm

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

Veeam Logoby Mike Resseler » Thu 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!)
Mike Resseler
Veeam Software
 
Posts: 3151
Liked: 362 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

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

Veeam Logoby RobC-ISGI » Mon 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.
RobC-ISGI
Lurker
 
Posts: 1
Liked: never
Joined: Mon Oct 05, 2015 6:38 pm
Full Name: WWIP ITSupport


Return to Veeam Agent for Windows



Who is online

Users browsing this forum: No registered users and 15 guests