| LINKS |
|
ApexSQL Knowledgebase Tips and How-to Articles for ApexSQL Tools Recover from rogue delete statement with no backup, and without a full database restore APPLIES TO ApexSQL Recover 2008.06.0838 and below SUMMARY This article describes how to recover data loss that occurred as a result of the DROP table operation, when there are no database or transaction log backups available and there is no possibility to create a full database restore. 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 sure that you detached the database and backed up the raw MDF and LDF files. Doing full backup won’t do the trick as it will just backup the pages in use and the active part of the transaction log whereas we need both the deallocated pages and the entire transaction log to maximize the chances of recovery. 2. Once you have backed up the files, please attach them as another database; put it into read-only mode. If this is not possible, then please put the original database into read-only mode. The less post-incident activities are performed on the database, the bigger the possibility for successful data recovery. 3. Open ApexSQL Recover and point to your SQL Server:  4. Select the ‘Recovery lost data due to Delete operation’ recovery option  5. Specify database the data should be recovered to:  6. Select the ‘Several sources are available for data recovery’ option  7. Specify the data sources:  8. And select the table(s) in which the data loss occurred:  9. Specify the path and the name for the recovery script and generate it:  10. Open the generated recovery script and review its contents to verify it contains the required data:  11. Run it against your database  SEE ALSO Recover from a rogue drop table 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 Recovering corrupted database Undoing schema changes (Drop Object) Recovering BLOB data from a SharePoint database Recover a single table from a full database backup POSTED BY Dmitriy Dyubchenko LAST UPDATED 24 June 2010 Labels: ApexSQL Recover |
