Your SQL Server database won't open, the MDF file is damaged, and the data inside it matters. SQL Recovery is built for that situation: it reads a corrupt MDF file and pulls the database objects back out.
Quick facts
- Supported databases: SQL Server 2000 through SQL Server 2012
- Trial: a free edition that lets you run the repair but not restore the repaired database
- Licenses: Personal, Business and Enterprise
Key features
Get back tables, triggers, rules and stored procedures
The tool recovers user defined data types, rules, defaults, checks, triggers, tables and stored procedures from a damaged database.
Keep your primary, foreign and unique keys
Database keys (unique, foreign and primary) are recovered along with the data.
Save to a database or to a SQL script
After recovery you can save into an existing database or write a SQL script file. This helps when the server is not available.
Try the repair before paying
The free trial runs the repair so you can see what the tool finds. Restoring the repaired database needs the full version.
Who it's for
You're the person responsible for a SQL Server database that has become inaccessible. The vendor says the interface is simple enough for someone with little technical background to use.
Pros and cons
- Pro: You can test the repair for free.
- Pro: It covers a wide range of SQL Server versions.
- Pro: You can save to a script when no server is available.
- Con: The trial cannot restore the repaired database.
- Con: It is aimed at MDF file corruption, not general database administration.
FAQs
Can I try it first?
Yes. The trial repairs the database but does not restore it.
Which SQL Server versions work?
SQL Server 2000 up to SQL Server 2012.
What can I recover?
Tables, triggers, rules, stored procedures, defaults, checks, user defined data types and keys.
Which license do I need?
The full version comes in Personal, Business and Enterprise licenses.