SQL add field record lost SQL data table lost column software added field before record lost

Customer Name a large enterprise
Data type SQL2005 Database
Data size 10g
Failure phenomena
One of the tables in the database was changed from the text field type to the varchar type, causing the table data to be partially lost. After the customer is changed to text type.
Processing results
After customers send us the documents, we first analyze the cause of this data loss, the text content stored in a field of type TextBox can be spread across pages, and changing to a varchar type will cause values beyond the length to be saved in the new varchar type field, resulting in a lot more data loss than this length . According to the log analysis customer has changed this text field to varchar (800) and char (800) This is pure toss, the data lost a half
Solution Solutions
Restore the original table records from MDF file recovery about 5W more than a row, because there is coverage so incomplete, and then from the log to extract the missing part of the record, and then add to restore the original table inside, the total record number of 91734 with the customer later with the changed record 10,644 more. After the customer inspection data, nearly 100% recovered successfully. Very satisfied with the result.
Microsoft Asia Database Recovery Center reminds you, if your data is very important in the case of many attempts to contact us, perhaps it is your last glimmer of light.
You can add our buckle
Buckle: 3485527083

SQL add field record lost SQL data table lost column software added field before record lost