| 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: ApexSQL Recover |
