Recovery for SQL Server

Data fix software for corrupted Microsoft® SQL Server databases, backups and logs

Product

Product information

Free demo version is available:

Download


Order

Place an order

Upgrade

Sales assistance
1-888-827-9543

Resellers

Licensing


Support

Request support

Frequently asked questions


Company

Profile

Products

Customers

Recovery for SQL Server Icon
Recovery for SQL Server
Recovery for SQL Server

Recovery for SQL Server repairs corrupted SQL Server databases, backups and logs (.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

Attention: make backup copies of corrupted file(s) before fix

Click Fix to start

Version 4.7
Copyright © Recoveronix Ltd.

Recovery for SQL Server repairs corrupted SQL Server databases, backups and logs (.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 data is saved into a set of SQL files to be used for rebuilding SQL Server database. This can be done manually or using an auto-generated rebuild batch file.

New major feature: view and selectively extract database, backup and log items using the Recovery for SQL Server Data Browser.

Free Demo

Download a free demo version of Recovery for SQL Server.

Related Products

DBRecovery 2018 Suite

The suite integrates multiple database fix utilities.

Data Recovery Services

Is there an associated hardware problem or does the case need custom approach? Try our custom services.


Features

New in Recovery for SQL Server 4.7:

Standard features:

Data Browser

Data Browser is a new feature bundled with the product, available from the same program group where Recovery for SQL Server is installed. It is a separate granular data fix utility to view and extract individual items from database, backup and log.

Always try the Data Browser if...

Tip: Recovery for SQL Server Data Browser can be used as a preview and fix tool on both corrupted and healthy files.

Limitations

System Requirements

SQL Server Fix Techniques

Recovery for SQL Server analyzes each cell in corrupted sql server file and restores all available data using high-quality low-level algorithms.

All available data is saved into a set of SQL files to be used for rebuilding SQL Server database.

No user skills or resources required.

How to Fix Damaged SQL Server Database

To fix corrupted sql server document follow provided steps:

  1. Download the demo version of Recovery for SQL Server at:
    http://www.officerecovery.com/mssql/download_demo.htm
  2. Install the program, follow the instructions and wait for Recovery for SQL Server fixes your mdf, ndf or bak document
  3. Estimate demo results of fixed sql server file
  4. If fix process succeeds, click Purchase full version of Recovery for SQL Server to get the full version of the program. Otherwise, contact our technical support team.

Upgrading Recovery for SQL Server Demo To Full Version

The demo version recovers 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. Full version will recover the demo-limited rows as well.

To order the full version either press the Order button on the application's toolbar.

Questions And Answers

 
Q: Can Recovery for SQL Server repair my SQL Server database, backup and log?
A: The effective way to find out if a SQL Server database, backup and log is recoverable is to try the demo version of Recovery for SQL Server on it. Visit the Demo page for a free copy of the demo.

Product specifications with lists of items recovered and not recovered is available at the Product Information page.

Note: Always backup your original corrupted SQL Server database, backup and log before proceeding with any fix activity!

 
Q: What limitations does the demo version of Recovery for SQL Server have?
A: The demo version fixes 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. Full version of Recovery for SQL Server will fix the demo-limited rows as well.

No additional tables or records are recovered by commercial version of Recovery for SQL Server if not present in demo output.

 
Q: I have tried the demo. How do I decide whether to purchase the full version of Recovery for SQL Server?
A: Evaluating the results of demo fix can help in making the decision.

 
Q: What are the differences between product licenses?
A: Details of current licensing scheme are described at the Licensing page.

 
Q: Why do results of fix contain less data than the original SQL Server database, backup and log?
A: 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: Running Recovery for SQL Server from command line (through Windows Start -> Run menu).
A: If your license type is Enterprise or Service, you can run Recovery for SQL Server from command line and use these calls in your batch files. Standard version does not support command line. The format for command line call is:

msr.exe <original filename with path> "<path to directory to store the recovered file(s)>"
(without angle brackets).

Please note that the directory for recovered file(s) should be created before starting the fix.

Command line mode supports patterns '*' (replaces group of symbols) and '?' (replaces one symbol).

 
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.

About sqlcmd.exe on Microsoft.com:

 
Q: I have 3 databases, backups and logs in hand: MDF, NDF, LDF. Which one should I use to fix my database information?
A:
  1. MDF is for SQL Server Master Database File
  2. NDF is for SQL Server Secondary Data File
  3. LDF is for SQL Server Transaction Log File

Recovery for SQL Server requires MDF file to fix 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 fix: Recovery for SQL Server will use it to improve the quality of fix as much as possible.
LDF file is not necessary at all.

 
Q: The corrupted database, backup and log consists of a large number of records. Is there a way to set the number of sql scripts that Recovery for SQL Server creates during fix session?
A: Recovery for SQL Server creates equal or less than 9999 sql scripts. By default, each script contains 2000 lines. To change the maximum size of the split script(s), set the MaxLines system registry value (type REG_DWORD) in the HKEY_CURRENT_USER\Software\Recoveronix\MSSQLRecovery key.

I need fix for... Use the product reference to locate a fix solution for your application file, database, server or media.

Office and Windows

Email

Access (mdb, mda, accdb)

Exchange Server (edb, stm)

Excel (xls, xlsx, xla)

Exchange OST (pst)

Money (mny, mbf)

Lotus Notes (nsf)

QuickBooks (qbw, qba)

OneNote (one)

PowerPoint (ppt, pptx, pps)

Outlook (pst, ost)

Project (mpp)

Outlook Express (mbx, dbx)

Publisher (pub)

Undelete for Outlook (pst)

Word (doc, docx, rtf)

Works (wps, xlr, wdb)

Windows Backup (bkf, zip)

Windows Registry

Servers

Databases

Active Directory (dit)

Access (mdb, mda, accdb)

BizTalk (mdf)

FileMaker Pro (fp5, fp7)

Exchange Server (edb, stm)

Interbase / Firebird (gdb, fdb)

Lotus Notes (nsf)

MySQL (myd, myi)

Project Server (mdf)

Oracle (dbf, ora, dmp)

SharePoint (mdf)

Paradox (db)

VMWare (vhd, vmdk)

PostgreSQL

Virtual PC (vhd, vmdk)

SQL Server (mdf, ndf, bak, ldf)

Citrix Xen (xva, ova, img)

Sybase (dat)

Sun xVM (vhd, vmdk)

SQL Anywhere Server (db)

Visual FoxPro (dbf)

Other

Media

Zip

Flash Drive

PDF

Hard Drive

JPEG, GIF, TIFF, BMP, PNG or RAW

CD and DVD

Photo File (jpeg, tiff)

Diskette

Photoshop (psd, pdd)

Removable Disk

WordPerfect (wpd, rtf)

Virtual Drive (vhd, vmdk, ova)

Writer (odt)

Calc (ods)


No portion of this website may be reproduced without express written permission by OfficeRecovery
Copyright © 1998-2017 OfficeRecovery

recover sql server database | repair sql server database | fix error opening sql server file