41348members
184417posts

Duplicate key in SQL.

Duplicate key in SQL.

Issue

Unable to truncate extended log table past August 2, 2012.

Getting a Duplicate Key error in SQL.

Environment

  • SQL
  • Extended Logs

Cause

Database corruption. 

Resolution

  • Key duplication indicates that the database integrity has been damaged. 
  • Key duplication cannot be repaired.
  • The customer will have to rebuild their site database.
Tags (3)
Labels (1)
No ratings