title: How to resolve "Violation of PRIMARY KEY constraint" after a DB reset
body: <p><strong>Use Case:</strong>
  I am performing performance execution on an database and I am trying to do following:
  I took an backup of the database (the mdf and ldf file) at the early stage (lets called a "<strong>baselinecopy</strong>").
  After that I execute some performance script .And the database reach to <strong>baselinecopy+Additional_Row</strong> (let it be "NewDatabase") from the test.</p>
  
  <p>Then I replace the database <strong>baselinecopy with NewDatabase</strong> &amp; start the server. While trying to perform operation on application it is giving me Violation of PRIMARY KEY constraint to test_order. Cannot insert duplicate key in object.</p>
  
  <p>I check the "IDENTITY" but the table has no identity set.</p>
  
  <p>Any thoughts on this ?  </p>