FAQ-Wiki-SQL Server

When I recover data with Recovery Toolbox for SQL Server, excessive or incorrect values appear in Primary Key fields

Answer:
  • If a value in a Primary Key field is incorrect (for example, it is negative or several dozen times greater than all other values), it means that the source data were seriously damaged and it is impossible to recover it completely.
  • If duplicate values appear in Primary Key fields, it means that the program has recovered sheets with data that should have been marked for deletion in the database (mdf, ndf files). But actually there is no mark that the sheet with data should be deleted. And therefore the program recovers data from all sheets. It results in excessive recovered data and the developers of Recovery Toolbox for SQL Server could not find criteria for filtering out excessive entries. In this case, database administrators and/or software developers make the final decision about excessive entries in the recovered database that should be deleted.