SysTools SQL Recovery Tool is an advanced software designed to restore SQL Server databases to a healthy state by repairing corrupt MDF and NDF files. It allows users to regain all database functions quickly. The software facilitates the export of recoverable data to a new or existing SQL database, or to SQL-compatible scripts if SQL Server is not installed on the machine. It supports the recovery of deleted records from all SQL Server objects and can export table records into CSV format. The tool is also capable of repairing and recovering BLOB data, merging MDF and NDF files, and recovering data from SQL injection and ransomware-affected MDF files. It supports SQL Server versions 2022, 2019, 2017, 2016, 2014, 2012, 2008 R2, 2005, and 2000, and allows users to selectively save files with schema or schema and data while exporting the database. The utility supports exporting recovered data to SQL Server located on a network and offers a free demo version to test its features.

Features & Benefits

• Comprehensive Recovery
  • Recovers tables, triggers, rules, views, functions, stored procedures, and more.
• Deleted Record Recovery
  • Recovers deleted records in SQL Server from all objects.
• Flexible Export Options
  • Exports data into a new or existing SQL Server database, or SQL-compatible scripts.
• CSV Export
  • Exports table records into CSV file format.
• BLOB Data Recovery
  • Repairs and recovers BLOB data.
• MDF and NDF Merge
  • Merges MDF and NDF files in SQL Server database.
• Version Compatibility
  • Recovers SQL databases from versions 2022, 2019, 2017, 2016, 2014, 2012, 2008 R2, 2005, and 2000.
• Network Export
  • Exports recovered data to SQL Server located on a network.
• Selective Export
  • Saves files with schema or schema and data selectively.
• SQL Injection/Ransomware Recovery
  • Recovers data from SQL injection and ransomware-affected MDF files.
• Multiple NDF Support
  • Supports recovery from multiple .ndf files.
• Auto Detect NDF
  • Automatically detects storage of corresponding NDF files.
• Auto Detect Version
  • Automatically detects the version of SQL Server .mdf / .ndf files.
• Corruption Examination
  • Examines file corruption and prompts if the file is highly corrupted.
• Scanning Modes
  • Offers Quick Scan for healthy files and Advanced Scan for corrupted files.
• Scanning Details
  • Shows scanning details, including object count and collation name.
• Save/Load Scan
  • Saves and loads scanned SQL DB files (.str format) to save time.
• Index Recovery
  • Easily recovers all indexes of database tables.
• Key Recovery
  • Recovers all keys such as Primary key, Foreign key, etc.
• Data Type Support
  • Recovers and exports almost all data types easily, including ASCII and Unicode XML.
• Deleted Item Highlighting
  • Shows deleted, dropped, and truncated records and objects in Red.
• Data Highlighting
  • Shows database objects in Bold if they have data.
• Page-Wise Preview
  • Shows a preview of all records to users page-wise.
• Empty Table Detection
  • Detects if there are Empty Tables in SQL Server DB.
• Network Export
  • Exports data into SQL Server present in the same network.
• Authentication Options
  • Offers Windows and SQL Authentication to connect to SQL Server.
• Collation Setting
  • Features to set the Collation Type while exporting data.
• Dropped Table Schema Recovery
  • Easily recovers Dropped Table Schemas alone or with the entire database.
• Selective Object Export
  • Recovers and exports Selective Tables & Other Objects.
• Batch File Creation
  • Creates Batch Files to restore TScript files into the Server at once.
• Export Reports
  • Creates both Successful export reports and Failed reports.
• Counter DBCC CHECKDB Commands
  • Easily counter the DBCC CHECKDB command to repair the database.
• No SSMS Required
  • Users can execute their recovery procedure without installing SQL Server or SSMS.
• Faster Recovery
  • Works with double the speed of other solutions while maintaining accuracy.
• Regular Updates
  • Offers updated versions and free updates to users.
• Customized Results
  • Offers features that help users get selective and customizable results.