Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to enable archiving and am getting this error: Violation of PRIMARY KEY constraint 'archives_pk'. Cannot insert duplicate key in object 'dbo.SDE_archives'.

Is this saying that there is already a primary key in the dbo.SDE_archives table or there is already a primary key which is called archives_pk? I deleted all versions, unregistered as versioned and moved all edits to base, then re-registered as versioned and tryed to enable archiving again with the same error.

My overall question is, how do I approach the dba because I don't have access directly to management studio on SQL Server 2008 nor would I know what I am doing?..Thanks.

share|improve this question

By the error message you have mentioned, there seems to be a duplicate entry in the Archives table. Consult your DBA and delete the concerned record.

If feasible try to achieve a state zero compress and this should probably take care of the error.

Technical Article HowTo: Compress a versioned database to state 0

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.