DIY - Downloadable Repair Software - Try it FREE

When using an online repair service is not an option, try one of these downloadable utilities:

Besides the ability to recover information in-house, they provide unlimited multi-file recovery, advanced support options and many other features corporate users will appreciate.

OfficeRecovery Online Video Tutorial

“I'm not sure what had happened to the database, but it could not be opened. Your software did a full recovery and rebuild, and all went back to normal operation. I was impressed.”

Jim K.

“We had a severe crash on a SAN-disk shelf with following corruption of data. Recovery for SQL Server managed to recover the database tables in a database (it turned out that the backups were corrupt as well) but of cause a lot of the records were damaged. Still it helped us out of a possible worse situation.”

Noralf G.

“Our production server had a disk crash and we had backup but it was 2 days old. Thanks to Recovery for SQL Server we could restore almost everything to the time of the disk crash.

We have merged the data from the backup and from the recovery database to a new fresh database so we ultimately lost just a few rows in the production database.”

Martin W.

About OfficeRecovery for SQL Server Online

OfficeRecovery for SQL Server Online repairs corrupted SQL Server databases (.mdf, .ndf, .bak, .ldf).

Supported SQL Server versions:
2008 R2, 2008, 2008 x64, 2008 Express, 2005, 2005 x64, 2005 Express, 2000, 2000 x64, 7.0 and 6.5

The recovered datais saved into a set of SQL files to be used for rebuilding SQL Server database.

After the file is fixed, you can estimate the demo result and sign up for free recovery or purchase instant recovery results. Also, if the file is not successfully fixed, you can order a review by our experienced technical team.

Use Cases

SQL Server corruption repair service can be used in situations when sql server file cannot be successfully opened in Microsoft SQL Server and you see errors or warnings while opening.

To repair corrupted mdf or bak file quickly, upload the sql server database to our cloud recovery service using repair form on this page.

It is important to note that if the restore process succeeds you will receive ready-to-use repaired sql server file as an output of recovery process. You can get fully repaired sql server database by selecting free or paid option.

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
Supports Microsoft® SQL Server versions 2008 R2, 2008, 2008 x64, 2008 Express, 2005, 2005 x64, 2005 Express, 2000, 2000 x64, 7.0 and 6.5
Supports SCSU (The Standard Compression Scheme for Unicode)
Supports XML indices
Supports SQL Server 2008 encrypted files
Repairs compressed backups of SQL Server 2008
Repairs SQL Server 2005, 2008 compressed data (types ROW, RAGE)
Repairs varchar(max) data type
Log support for MS SQL Server 2005 and 2008.
Repairs Microsoft SQL Server backups for all versions
Repairs multi-volume database files
Repairs tables, stored procedures, views
Repairs predefined defaults, default values, rules, constrain "CHECKS", user data types ("Allow null", "default", "rule")
Repairs primary keys, unique key, indexes (including "IGNORE_DUP_KEY", "CLUSTERED", "STATISTICS_NORECOMPUTE", "FILLFACTOR"), foreign keys
Repairs SQL Server 2008 sparse columns
Repairs triggers
Repairs the sort order for index keys
Repairs deleted records and saves them in a separate SQL script
Repairs 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
Repairs Reports feature

OfficeRecovery for SQL Server Online File Repair Description

Corrupted sql server databases are files that suddenly become unusable and can't be opened with Microsoft SQL Server. There are several reasons why a sql server file may have been damaged. In some cases, it is possible to fix and recover the corrupt mdf (SQL Server 2008 R2, 2008, 2008 x64, 2008 Express, 2005, 2005 x64, 2005 Express, 2000, 2000 x64, 7.0, 6.5), ndf, ldf, bak file.

If your mdf, ndf, ldf or bak database has accidentally become corrupt/inaccessible for opening with the original software, don't lose heart! You do not have to buy expensive software to repair just one damaged sql server file anymore. OfficeRecovery for SQL Server Online represents you a new online service that will help you to restore a corrupted sql server database instantly. All you have to do is just to upload the corrupted mdf, ndf, ldf or bak file using your browser, estimate demo recovery results and choose a solution suitable for you.

OfficeRecovery Online for SQL Server supports Microsoft SQL Server 2008 R2, 2008, 2008 x64, 2008 Express, 2005, 2005 x64, 2005 Express, 2000, 2000 x64, 7.0, 6.5. The recovered data is saved a set of SQL files to be used for rebuilding SQL Server database.

OfficeRecovery for SQL Server Online offers free/gratuit and paid options to get full recovery results. Free recovery option means that you get full repair results absolutely free in 14-28 days. All you have to do is just to subscribe for free recovery results of your sql server file after the restore process. If you need to get the repaired mdf, ndf, ldf or bak file right now, instantly you just need to choose the paid option instead of the free one.

What if no data to recover detected in your damaged sql server file? You can order a non-refundable file review by our technical team. In some cases it is possible to retrieve data only manually.

Recovery for SQL Server Questions And Answers

Q:	Can Recovery for SQL Server repair my SQL Server database?
A:	The effective way to find out if a SQL Server database is recoverable is to try the demo version of Recovery for SQL Server on it using the upload form on this page.

Q:	What limitations does the demo version of Recovery for SQL Server have?
A:	The demo version of recovery results will contain a limited number of rows in each table. The remaining rows will contain "demo" in text fields and null values in other types of fields. The full version of recovery results will contain the demo-limited rows fully repaired as well. No additional tables or records are recovered in the full results if they are not present in demo output.

Q:	I have tried the demo. How do I decide whether to purchase the full recovery results?
A:	Evaluating the results of demo recovery can help in making the decision.

Why do results of recovery contain less data than the original SQL Server database?

This is normal. The damaged parts of your SQL Server database, backup and log will convert to zero size on output. The other common reason of file size decrease is when some of features of the original database, backup and log are not supported and therefore absent from the recovered database, backup and log. Demo-recovered database, backup and log is smaller because it mostly consists of demo placeholders than actual data.

Q:	After running Recovery for SQL Server on the corrupted database, backup and log, a folder with sql script(s) and batch file has been created. How could these files be transfigured into a new database, backup and log?
A:	To recreate database, backup and log, process resulting sql scripts starting with schema.sql and following by dataNNNN.sql. The database, backup and log will be recreated from scratch. To make the import procedure more convenient for the end-user an appropriate batch file is automatically created and put in the same folder as sql script(s).

Q:	When trying to execute the commit.bat file created by Recovery for SQL Server I receive the error which claims that isql.exe utility cannot be found. What should I use instead of missing program?
A:	This could happen if you are using SQL Server 2005. The isql.exe and osql.exe utilities are replaced by sqlcmd.exe in this release. To execute our batch file and recreate database automatically, please, do the following: create a link to the sqlcmd.exe called isql.exe and rerun commit.bat file. Alternatively, you can edit the batch file manually to make it use sqlcmd.exe instead of isql.exe.

I have 3 databases, backups and logs in hand: MDF, NDF, LDF. Which one should I use to recover my database information?

MDF is for SQL Server Master Database File
NDF is for SQL Server Secondary Data File
LDF is for SQL Server Transaction Log File

Recovery for SQL Server requires MDF file to recover database, backup and log. If you don't have an MDF, there's no way to restore your data.
In case you have an NDF, please, place it in the same directory as MDF before processing with data recovery: Recovery for SQL Server will use it to improve the quality of recovery as much as possible.
LDF file is not necessary at all.

Repair SQL Server Database ONLINE

Repair, discuss and troubleshoot Microsoft® SQL Server database corruption online

OfficeRecovery for SQL Server Online File Repair Description

Recovery for SQL Server Questions And Answers

recover sql server database online instantly | fix sql server file online instantly | restore sql server database online instantly | fix error opening sql server file online instantly