Features
New in Recovery for SQL Server 4.7:
- Supports SQL Server 2022, 2019, 2017, 2016, 2014. 2012, 2008 R2
- Supports SCSU (The Standard Compression Scheme for Unicode)
- Supports XML indices
- Supports SQL Server 2008 encrypted files
- Recovers compressed backups of SQL Server 2008
- Recovers SQL Server 2005, 2008 compressed data (types ROW, RAGE)
- Recovers SQL Server 2008 filestream data type. Please note that database should be recovered on the same computer where the original database is located
- Recovers varchar(max) data type
Standard features:
- Processes a corrupted Microsoft SQL server database file (.mdf, .ndf, .dat, .ldf, .bak) and creates a SQL script with recovered database structure and data
- Log support for MS SQL Server 2005 and 2008.
- Recovers Microsoft SQL Server backups for all versions
- Recovers multi-volume database files
- Recovers tables, stored procedures, views
- Recovers predefined defaults, default values, rules, constrain "CHECKS", user data types ("Allow null", "default", "rule")
- Recovers primary keys, unique key, indexes (including "IGNORE_DUP_KEY", "CLUSTERED", "STATISTICS_NORECOMPUTE", "FILLFACTOR"), foreign keys
- Recovers SQL Server 2008 sparse columns
- Recovers triggers
- Restores the sort order for index keys
- Recovers deleted records and saves them in a separate SQL script
- Recovers partly damaged records, storing them in a separate batch file
- Database rebuilding batch is generated automatically
- The resulting database rebuilding script is split into multiple parts for the convenience of viewing and editing
- National characters (umlauts, hieroglyphs etc) are now recovered
- Recovery Reports feature
- Full install/uninstall support