Standalone backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)
Post Reply
AlexLeadingEdge
Expert
Posts: 274
Liked: 32 times
Joined: Dec 14, 2015 9:42 pm
Contact:

Violation of PRIMARY KEY constraint

Post by AlexLeadingEdge » Sep 20, 2017 9:46 pm

Hi guys,

My motherboard died last night and I replaced it this morning with one of the same make and model. I'm now getting this error message when a backup is manually or automatically run:

21/09/2017 10:10:06 AM :: Error: Violation of PRIMARY KEY constraint 'PK_GuestDatabase'. Cannot insert duplicate key in object 'dbo.Backup.Model.GuestDatabase'. The duplicate key value is (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx). The statement has been terminated.

I tried to submit a ticket but I'm also getting this error message:

Online support system is temporarily unavailable, try again later.

AlexLeadingEdge
Expert
Posts: 274
Liked: 32 times
Joined: Dec 14, 2015 9:42 pm
Contact:

Re: Violation of PRIMARY KEY constraint

Post by AlexLeadingEdge » Sep 21, 2017 3:39 am

Finally got it to make a ticket: 02317970

Dima P.
Product Manager
Posts: 9911
Liked: 790 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Violation of PRIMARY KEY constraint

Post by Dima P. » Sep 23, 2017 5:17 pm

Hi Alex,

Although the hardware replacement scenario should work (may result a new full due the change of bios uid), I can’t say much about this error. Please keep working with our support team and let us know how it goes. Cheers!

AlexLeadingEdge
Expert
Posts: 274
Liked: 32 times
Joined: Dec 14, 2015 9:42 pm
Contact:

Re: Violation of PRIMARY KEY constraint

Post by AlexLeadingEdge » Sep 24, 2017 10:33 pm

Hi Dima,

They got me to rebuild the Veeam database using these instructions, seems to be working fine now:

Step 1 - Open up RegEdit
Step 2 - Look for HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Endpoint
Step 3 - Look for the DWORD value called ReCreateDatabase and assign to it 1 (decimal)
Step 4 - Close regedit, open up the services.msc console, and re-Start the Veeam Agent for Windows (or Endpoint) service manually.

Dima P.
Product Manager
Posts: 9911
Liked: 790 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Violation of PRIMARY KEY constraint

Post by Dima P. » Sep 26, 2017 11:48 am

Alex,

Looks like recreating the database is the cure against all issues. Thanks for sharing!

Post Reply

Who is online

Users browsing this forum: No registered users and 8 guests