Hi All. Hope you great. I most likely corrupted my veeam DB after upgrade. Even after repository re-scan my Veeam B&R is upset with my default repository. I recall there was a regedit command to force veeam to rebuild its DB. If anyone can help I will really appreciate it. Here is the error as attached.
I would love to solve this. If anyone can assist.
Best answer by Chris.Childerhose
Okay here we go. It failed on a import of:
2021-06-21 11:12:09 PM Warning Failed to import backup path J:|Backup|VMPASTEL2012|VMPASTEL2012.vbm Details: Violation of PRIMARY KEY constraint 'PK_GuestDatabase'. Cannot insert duplicate key in object 'dbo.Backup.Model.GuestDatabase'. The duplicate key value is (f77f2176-00fd-4c3d-a546-e53fcd08cdc8).
J: Is local/ Default repository. Im not too sure how to fix this error.
This is a DB update issue for one VM. Might be better to recreate the job for this one and a new record in the database. If it is only this one that is pretty good.
If you need this fixed then Support is the next avenue.
+21I believe the registry command was for Enterprise Manager. For Veeam itself you can run the DBConfig utility to create a new DB - Using Veeam.Backup.DBConfig.exe Utility - Veeam Backup Guide for vSphere
Just change the DB name to a new one -
Awesome you the man!. Let me try that. After I create the new DB do restore the configuration backup again? I really appreciate your help.
Sincerely
Jay
+21Awesome you the man!. Let me try that. After I create the new DB do restore the configuration backup again? I really appreciate your help.
Sincerely
Jay
Yeah once you create the new DB you can do a Config Backup restore again if needed. Then I would suggest to clean up the unused DBs from the SQL server. 
Perfect let me give it a try. Will report in . Doing it now.
Jay
Great I am waiting for the DB to sync before I Enable the Jobs. I think where I could of gone wrong before- During the restore process I did not select the password of the local server (Default Repository) - but rather chose a NAS. I hope the default repository's will work now as I gave it that password asked (If the password has changed) I hope that makes sense. Lets see it is Syncing. Ill report in soon.
Jay
About 9TB of backups on the default repository so I imagine this process will take some time?
Thanks so much guys! Lets see what happens.
Jay
Okay here we go. It failed on a import of:
2021-06-21 11:12:09 PM Warning Failed to import backup path J:|Backup|VMPASTEL2012|VMPASTEL2012.vbm Details: Violation of PRIMARY KEY constraint 'PK_GuestDatabase'. Cannot insert duplicate key in object 'dbo.Backup.Model.GuestDatabase'. The duplicate key value is (f77f2176-00fd-4c3d-a546-e53fcd08cdc8).
J: Is local/ Default repository. Im not too sure how to fix this error.
+21Okay here we go. It failed on a import of:
2021-06-21 11:12:09 PM Warning Failed to import backup path J:|Backup|VMPASTEL2012|VMPASTEL2012.vbm Details: Violation of PRIMARY KEY constraint 'PK_GuestDatabase'. Cannot insert duplicate key in object 'dbo.Backup.Model.GuestDatabase'. The duplicate key value is (f77f2176-00fd-4c3d-a546-e53fcd08cdc8).
J: Is local/ Default repository. Im not too sure how to fix this error.
This is a DB update issue for one VM. Might be better to recreate the job for this one and a new record in the database. If it is only this one that is pretty good.
If you need this fixed then Support is the next avenue.
Great I can do that. Now the import of the backups to this Job? Bit scared :D
Jay
+21Great I can do that. Now the import of the backups to this Job? Bit scared :D
Jay
You should be good. π
Thanks so much for the help. It mostly restored all of it. I will get the others going again. I really appreciate your help.
+21Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
