MS SQL Recovery is a complete solution for recovering data from MS SQL databases. In a single package, the tool combines some powerful recovery algorithms allowing database administrators to easily recover damaged or deleted MS SQL databases as well as completely reconstruct databases which have been severely damaged. The software allows the user to recover databases which have been deleted. To make this possible, the program uses some particularly advanced data recovery algorithms which allow it to automatically locate and recover the data from MS SQL databases. These database files can be also recovered from drives which are damaged in some way. If the drive is corrupted, the file system is damaged or for some reason, the drive is inaccessible, MS SQL Recovery provides users with the highest chance possible of retrieving and rebuilding the lost data.
In addition to being able to recover deleted files, MS SQL Recovery also provides a great way of repairing corrupted data. In situations where the database files are damaged in some way, or if only certain sections of the data are available, the software can apply a variety of database repair procedures which allow it to reconstruct tables. The repaired and recovered data can then be exported into either the MySQL or MyISAM/InnoDB formats. ADO export is supported as well.
For maximum convenience and versatility, DiskInternals MSSQL Recovery also provides various different operation modes including full automatic, semi-automatic and manual. Which mode is used depends mostly on the severity of the damage as well as the level of knowledge and experience of the user. Working in fully automatic mode, the MS SQL recovery software will recover and repair databases when it can without requiring any interaction from the user. In situations where this is possible, the task of recovering data is easier and faster. With semi-automatic mode, users can modify the table structure of the database before the recovery process is carried out. Finally, manual mode allows the more experiences of database administrators to completely modify or manually recreate the structures of severely damaged databases. This is necessary in cases when only certain sections of the original data are available for retrieval.
A visual preview feature provides users with the ability to see a complete preview of any recoverable data before the recovery process is actually carried out. This feature displays many data types including images, certain office-document types and plain text. More advanced features include the support for ADO export. Additionally, as much as 2 GB can be recovered for a single data field.
For the very best multilingual support, MS SQL recovery can also be carried out with Unicode compatibility. This feature includes support for many different characters and scripts, making it ideal for working with data in a huge variety of different languages written in character sets beyond the standard ASCII. Supported databases include any created with MS SQL Server 2008, 2005 and 2000, including 64 bit versions and Express editions.
For more information or to download a trial version, visit http://www.diskinternals.com/mssql-recovery/.
James Cooper is a database developer and administrator who has used MS SQL recovery tools on a number of occasions to retrieve databases from damaged server drives.