For the best web experience, please use IE11+, Chrome, Firefox, or Safari

SQL Server data recovery

ApexSQL Recover is a SQL Server data recovery tool which recovers deleted and truncated data. It recovers objects and data lost due to drop operations and it also recovers BLOBs as files. Additionally, ApexSQL Recover can be used to read transaction log files and backups, allow users to analyze and investigate audited operations in a comprehensive grid, as well as to create rollback and replay scripts for all DML and DDL changes.

An introduction to ApexSQL Recover 03:38


  • Recover deleted, dropped and truncated data

  • Reverse inadvertent or malicious database changes

  • Rollback or replay any DDL or DML change

  • Recover deleted data and files from SharePoint

  • Extract data directly from backup files

  • Extract BLOBs stored as files

  • Recover deleted BLOBs

  • Isolate specific SQL Server operations


Deleted data recovery

Recover data lost due to DELETE operations. Learn more

Truncated data recovery

Recover data lost due to TRUNCATE operations. Learn more

Dropped data recovery

Recover data lost due to DROP operations. Learn more

Table schema restore

Recover dropped table schemas. Learn more

DML and DDL changes roll back

Reverse inadvertent or malicious database changes to repair affected schema and data. Recover from specific loss/damage without relying on full database restores. Create undo scripts for specific operations to rollback data and schema to its original state

DML and DDL changes roll forward

Replay DML and DDL changes made to the database. Create redo scripts and execute them against databases to repeat operations originally executed

Direct-to-database recovery

Recover data directly to a database. Recover lost tables directly to a database. Including tables containing calculated columns or tables with missing schema and user defined data type definition

BLOB recovery and extraction

Recover deleted BLOBs and extract BLOBs as data files. Ideal for SharePoint recoveries. Learn more

Database backup restores for specific tables

Quickly extract full table schema and data directly from database backups without restoring the backup itself. Learn more

Multiple data source types support

Recover from live databases and transaction logs, detached database and transaction log files as well as native or compressed transaction logs and database backups. Learn more

Change isolation

Isolate specific SQL Server operations by user, date, object, change type, and more. Utilize advanced grid search algorithms including regular expressions, operation details and various filters to inspect and isolate operations for recovery

Visual themes

Customize the visual appearance with interface themes. Learn more

Why ApexSQL Recover?

Disaster recovery

Discover and identify inadvertent transactions and roll them back to repair damaged data without risking further data loss. Learn more

Zero data loss restores

Ensure that no data or structure changes are lost during backup restores by capturing transactions made during the backup process and replaying them.

Row-level recovery

Perform row-level recovery by reading the data from different transaction log files without restoring the entire database. Learn more

Deleted data recovery

Rollback inadvertent delete operations and recover lost data. Learn more

Dropped data recovery

Recover data lost due to drop table operation. Learn more

Table structure recovery

Recover entire table structures lost due to drop table operation. Learn more

Truncated data recovery

Rollback truncate operation and recover lost data. Learn more

Point in time restores

Roll back selected portions of a SQL Server database to a specific point in time without affecting the rest of the database. Learn more

DDL recovery and replay

Roll back/forward any structure changes on SQL Server database tables. Learn more

No downtime/data loss migrations

Ensure that no transactions are missing, after migration downtime ends, by replaying “missing” transactions directly to the migrated database by reading the transaction log files. Learn more

SQL injection attacks

Identify changes and damage due to SQL injection attacks and repair the damage by rolling back the changes. Learn more

Extraction directly from backup

Extract data and table structure directly from a database backup without restoring it. Learn more

BLOB data recovery

Directly recover deleted BLOB data. Learn more

BLOB extraction

Extract BLOB data as data files directly to local or remote drives. Learn more


We have successfully recovered more than a billion records. First, I didn't believe it could. But ApexSQL Recover sorted it all out. And the support team helped us kindly and swiftly. Lots of thanks

Baris Dur

Federal Emergency Management Agency

Brian, thank you very much for your help with getting us this product today. I have been using the ApexSQL Log + ApexSQL Recover trials for the past few days and they are outstanding. I just used the ApexSQL Recover tool to recover about some data that would have taken numerous work hours to re-enter, so thanks again

Christopher R. Wujciak IT Database & Websites Manager

Conestoga Wood Specialties

There was an UPDATE run without a WHERE clause that destroyed critical data in 8500 rows. When we went to restore from a backup we discovered that the backups hadn’t been running for over 2 months. Your product restored ALL the data and saved the day! Please give the engineers that made this product a huge THANK YOU!!! for saving us from what would have been a complete disaster!

Aaron Sears Conestoga Wood Specialties

Get started now

Recover damaged, deleted, dropped or lost data.