LINKS  

ApexSQL Knowledgebase

Tips and How-to Articles for ApexSQL Tools


Recover a single table from a full database backup

APPLIES TO
ApexSQL Recover 2008.06.0838 and below

SUMMARY

This article describes how to recover table data lost when there is no possibility to create a full database restore and only a full database backup is available.
Note: ApexSQL Recover supports recovery of BLOB values from database files (online, detached and database backups) only. Recovery of BLOB values from transaction log files is not supported yet.

DESCRIPTION
1. Please make a full database backup and copy it to the machine where ApexSQL Recover is installed.

2. Open ApexSQL Recover and point to your SQL Server:


3. Select the ‘Recover table data from a database backup’ recovery option


4. Specify the database backup you want to recover from:


5. Select the tables you want to recover:


6. Specify the path for the recovery script and generate it:


7. Open the generated recovery script and review its contents to verify it contains the required data:


8. Run it against your database.


SEE ALSO
Recover from rogue delete statement with no backup, and without a full database restore
Recover from a rogue truncate table statement with no backup, and without a full database restore
Recover from a rogue drop table statement with no backup, and without a full database restore
Recovering corrupted database
Undoing schema changes (Drop Object)
Recovering BLOB data from a SharePoint database

POSTED BY
Dmitriy Dyubchenko


LAST UPDATED
24 June 2010

Labels:



© 2010 ApexSQL LLC All Rights Reserved | 1.919.968.8444 | Contact Us | Terms of Use | Privacy Policy