| By product |
| Other |
|
Knowledgebase Tips and How-to Articles for ApexSQL Tools Why doesn't ApexSQL Recover recover indexes, primary keys and identity for dropped data recovery Applies to ApexSQL Recover Summary When I try to recover data from a drop table operation, ApexSQL Recover does not generate a code for the primary key and other indexes Description The simplest form of table schema is recovered intentionally. No primary key, default values or indexes are created - just column names with its data types. This security measure is used because recovery process is not always unambiguous and can lead to duplicated rows depending on the database. Recovering full table structure could lead to conflicting INSERT operations and possible data loss. Updating to the full structure has to be done manually by users. Last update December 26, 2011 Labels: ApexSQL Recover |
