SysTools MDF Viewer Pro is designed to repair and recover corrupt MDF and NDF files from SQL Server databases. It allows users to recover database objects such as records, tables, triggers, rules, and functions while preserving data integrity and maintaining the original structure and properties. The software supports both primary and secondary database files and is compatible with SQL Server versions up to 2022 and earlier. It offers two scanning modes: Quick Scan for normal corruption and Advanced Scan for severe corruption. The tool can recover deleted SQL table data and provides a preview of deleted database objects in red color. Users can export recovered data directly to a SQL Server database or as SQL Server compatible scripts. The software automatically detects the SQL Server version of the MDF or NDF file, and it supports user-defined schemas, XML data types, and advanced data types like Datetime2 and hierarchyid. It also addresses issues where SQL databases are marked as SUSPECT, providing a solution to repair and recover the database. The software supports Windows 64-bit operating systems.

Features & Benefits

• SQL File Recovery
  • Recovers tables, stored procedures, functions, views, rules, triggers, and associated keys and data types.
• Two Scan Modes
  • Offers Quick Scan for normal corruption and Advanced Scan for severe corruption.
• MDF & NDF File Recovery
  • Recovers both primary (MDF) and secondary (NDF) database files.
• Recover Deleted SQL Table's Data
  • Recovers deleted SQL database table data and other objects, previewing deleted items in red.
• SQL 2022 Database Recovery Export
  • Supports recovery and export of SQL Server databases from versions 2022, 2019, 2017, 2016, 2014, etc.
• Supports Primary / Foreign Key
  • Supports the recovery of both primary and foreign keys during database export.
• Supports User Defined Schema
  • Supports and exports database tables with standard and user-defined schemas.
• Windows 64 Bit OS Version Supported
  • Supports all Windows versions, including 32-bit and 64-bit versions.
• Option to Save Large File Scan
  • Saves scanned files as .str files to resume the process later, saving scanning time.
• Preview Database Components
  • Previews scanned and recovered database items with item counts in the built-in database viewer.
• Auto Detect SQL Server Version
  • Automatically detects the SQL Server version of the MDF or NDF file.
• Export to SQL Server Database
  • Exports recovered files directly to a live SQL Server database.
• Export as Compatible SQL Scripts
  • Exports files as SQL Server compatible SQL scripts (.sql files).
• Export Schema / Schema & Data
  • Exports the database with only the schema or with both schema and data.
• Supports XML Data Type
  • Recovers XML data from columns and variables of XML type.
• Export Selective SQL Files
  • Exports selective items from the MDF or NDF file.
• SUSPECT SQL Database Recovery
  • Repairs and recovers SQL databases marked as SUSPECT.
• Advance Data Type Support
  • Supports advanced data types like Datetime2, datetimeoffset, sql_variant, hierarchyid, geometry & geography.