Category Archives: SQL

Customized User Friendly Report of Recovered Data and Secure Solutions to Data Management

Often we have recovered millions files and/or files which millions records or complex structures. How to present a user friendly report so that user can manage not only files and directories but also data inside files easily? Data Care Clinic has developed our own software tools to provide secure solutions to help our clients.

OnSite Data Recovery Service with Group Discount in Kitchener, Waterloo and Cambridge

Data Care Clinic, as a member of The Greater Kitchener Waterloo Chamber of Commerce, provides onsite data recovery service and technical support for data security and data management in Kitchener, Waterloo and Cambridge with group discount for member of The Greater Kitchener Waterloo Chamber of Commerce.

Data Recovery of Deleted Fragmented SQL Database Files

2U Dell server with 2 raid controllers 2 arrays: OS and Data. 30 GB database files were deleted.

To cover this mistake, battery on the raid card was replaced and disks from data array were offline. Disks were forced online and synced. IT person swapped disks to another server to force these disks on line. Wrong raid type was used. To make matters worse they used CHKDSK to data partition so MFT was damaged. There are several database files on this SQL server. Two of them need to be recovered.

A data recovery company was hired to recover these 2 database files. After 3 weeks scan and scan, they couldn’t get the deleted database files.

Data Care Clini has recovered SQL database files owing to reformatting or repartitioning unless database was rewritten completely. This data recovery company contacted Data Care Clinic for help. Data Care Clinic provides service to rescue partially overwritten database file.

From our experience, not all recovered database file can be used via client software though database file can be attached to SQL server successfully. After database file was attached, client can remotely check recovered database file using self-developed ERP software. Pay only after client validated the database file works normally and correctly.

After analysis, Data Care Clinic recovered these database files and successfully attached them to SQL server. Data records are correct.