Recovery for SQL Server is a useful utility that will help users to recover all the corrupted Microsoft SQL Server database files.

Recovery for SQL Server recovers corrupted Microsoft SQL Server database files (.MDF/.NDF).

Recovery for SQL Server creates Transact-SQL script that re-creates the database from the scratch.

Recovery for SQL Server is able to recover corrupted tables, views, stored procedures, triggers, etc. Both standard and user-defined data types recovery is supported. Also the software repairs damaged primary keys, unique key, indexes including "IGNORE_DUP_KEY", "CLUSTERED", "STATISTICS_NORECOMPUTE", "FILLFACTOR") and foreign keys.

Here are some key features of "MSSQLRecovery":

· National characters (umlauts, hieroglyphes etc) are now recovered
· Recovery Reports feature
· Processes a corrupted Microsoft SQL server database file (.mdf, .dat) and creates a SQL script with recovered database structure and data
· Supports Microsoft SQL Server 6.5, 7.0, 2000, 2005, 2005 Express Edition
· Recovers multi-volume database files
· Recovers Microsoft SQL Server backup 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 triggers
· Restores the sort order for index keys (SQL Server 2000 only)
· 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
· Full install/uninstall support


Requirements:

· RAM: 128 MB
· Hard Disk: minimum 5 MB of free space required for installation
· Display: 640 x 480 or higher resolution, 256 colors


Limitations:

· Free demo version of Recovery for SQL Server recovers a limited amount of corrupted data. The remaining recoverable data will be labeled as "demo" in the demo-recovered file. Full version of Recovery for SQL Server will recover the demo-limited data as well.

What's New in This Release: [ read full changelog ]

· Recovery Reports feature
· Bug Fixes