Note: Most of the data files for the test cases are downloadable. For some very large files, you can get it by send a request to us. |
||||||||||||
DataNumen SQL Recovery 7.1 | SQL Server DBCC CHECKDB & CHECKTABLE |
Recovery for SQL Server 4.7 | Kernel SQL Database Repair and Recovery Utility 13.5.1 | Stellar Phoenix SQL Recovery 5.0 | SQL Database Repair Tool 6.0 | Recovery Toolbox for SQL Server 2.1.5 | ApexSQL Recover 2014.01.1112 | SysTools SQL Recovery 6 | QuickData MDF Recovery 5.5 | Quick Recovery for SQL Server | Recoveryfix for SQL Database Recovery 12.03 | |
Recovery Rate |
||||||||||||
Average Recovery Rate* | 92.60% | 1.27% | 8.78% | 8.88% | 8.88% | 8.88% | 63.24% | 8.81% | 8.88% | 8.88% | 3.80% | 10.72% |
Case 1 (5MB corrupt MDF file in SQL Server 2005 Format) |
88.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 86.20% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
Case 2 (50MB corrupt MDF file in SQL Server 2005 Format) |
100.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 99.98% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
Case 3 (100MB corrupt MDF file in SQL Server 2008 Format) |
100.00% | 0.00% | 100.00% | 100.00% | 100.00% | 100.00% | 99.36% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% |
Case 4 (500MB corrupt MDF file in SQL Server 2008 Format) |
100.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 66.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
Case 5 (1GB corrupt MDF file in SQL Server 2008R2 Format) |
100.00% | 0.00% | 0.18% | 0.18% | 0.18% | 0.20% | 53.28% | 0.00% | 0.20% | 0.20% | 0.00% | 0.20% |
Case 6 (2GB corrupt MDF file in SQL Server 2008R2 Format) |
100.00% | 0.00% | 49.60% | 50.60% | 50.60% | 50.60% | 53.26% | 50.10% | 50.60% | 50.60% | 0.00% | 69.00% |
Case 7 (4GB corrupt MDF file in SQL Server 2012 Format) |
100.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
Case 8 (8GB corrupt MDF file in SQL Server 2012 Format) |
100.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 77.80% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
Case 9 (10GB corrupt MDF file in SQL Server 2014 Format) |
100.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 78.50% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
Case 10 (15GB corrupt MDF file in SQL Server 2012 Format) |
100.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 80.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
OS Support |
||||||||||||
32bit Windows (Windows XP/Vista/7/8/10/11/ Server 2003/2008/2012/2016/ 2019) |
Windows Vista unsupported | Windows XP/ Server 2003 unsupported |
||||||||||
64bit Windows (Windows XP/Vista/7/8/10/11/ Server 2003/2008/2012/2016/ 2019) |
Windows 8 unsupported | Windows Server 2008/Vista unsupported | Windows Server 2003 unsupported |
|||||||||
SQL Server Support |
||||||||||||
32bit SQL Server (2005/2008/2008R2/2012/2014) |
||||||||||||
64bit SQL Server (2005/2008/2008R2/2012/2014) |
SQL Server 2014 unsupported | |||||||||||
Input/Output File Format Support |
||||||||||||
Input MDF file created by 32bit SQL Server (2005/2008/2008R2/2012/2014) |
SQL Server 2008R/2012/ 2014 unsupported |
|||||||||||
Input MDF file created by 64bit SQL Server (2005/2008/2008R2/2012/2014) |
SQL Server 2008R/2012/ 2014 unsupported |
|||||||||||
Output file in MDF format and SQL plain text format | SQL plain text unsupported |
MDF unsupported | MDF unsupported | |||||||||
Large MDF File Support |
||||||||||||
Recover MDF files as large as 16 TB | ||||||||||||
Capabilities in Recovering Objects |
||||||||||||
Recover the structure and data in the tables | ||||||||||||
Support all data types | XML type unsupported | XML type unsupported | XML type unsupported | XML type unsupported | ntext, nvariant, sql_variant, varbinary and XML type unsupported |
ntext,nchar, nvarchar, varbinary, sql_variant, xml types unsupported |
ntext,nchar, nvarchar, varbinary, sql_variant, xml types unsupported |
ntext,nvarchar, varchar,text, smallmoney, image, xml types unsupported |
xml type unsupported | |||
Support sparse column | Yes (only support SQL Server 2008 format) |
|||||||||||
Recover deleted records | ||||||||||||
Recover multiple files, including MDF file and its associated NDF files | ||||||||||||
Other Features |
||||||||||||
Support to repair MDF files on corrupted media, such as floppy disks, Zip disks, CDROMs, etc. | ||||||||||||
Support to repair a batch of MDF files. | ||||||||||||
Support to find and select the MDF files to be repaired on the local computer, according to some search criteria. | ||||||||||||
Support integration with Windows Explorer, so you can repair an MDF file with the context menu of Windows Explorer easily. | ||||||||||||
Support drag & drop operation. | ||||||||||||
Support command line (DOS prompt) parameters. | ||||||||||||
Support 95 languages, including: English,Bulgarian,Czech,Danish,German,Greek,Spanish,Estonian,Finnish, French,Hungarian,Indonesian,Italian,Japanese,Korean,ithuanian,Latvian, Norwegian,Dutch,Polish,Portuguese,Romanian,Russian,Slovak,Slovenian, Swedish,Turkish,Ukrainian,Chinese(Simplified),Afrikaans,Albanian, Amharic,Arabic,Armenian,Assamese,Azerbaijani,Basque,Belarusian, Bengali,Bosnian,Catalan,Chinese(Traditional),Corsican,Croatian,Divehi, Filipino,Frisian,Galician,Georgian,Gujarati,Hausa,Hebrew,Hindi,Icelandic, Igbo,Irish,Kannada,Kazakh,Khmer,Kinyarwanda,Kyrgyz,Lao, Luxembourgish,Macedonian,Malay,Malayalam,Maltese,Maori,Marathi, Mongolian,Nepali,Oriya,Pashto,Persian,Punjabi,Sanskrit,Scottish Gaelic, Sesotho,Serbian,Sinhala,Kiswahili,Tajik,Tamil,Tatar,Telugu,Thai,Turkmen, Urdu,Uyghur,Uzbek,Vietnamese,Welsh,isiXhosa,Yoruba,isiZulu |