LINKS
SITE FEED
Support Forum
The fastest and most effective to get answers to your questions quickly.
FAQs 
Quick answers to common questions.
Troubleshooting
Known issues and basic troubleshooting techniques for problems or unexpected behaviors.
Knowledgebase
Technical tips, How-to articles, and other tutorials about ApexSQL Tools.
Online Documentation
All of our help files for download or convenient viewing online.
Videos
Watch product demos, training videos, or tutorials of our products' main features.
|
ApexSQL Knowledgebase Tips and How-to Articles for ApexSQL Tools Recover from a rogue drop table statement with no backup, or without having to do a full restore DESCRIPTION This article describes how to recover data lost occurred by the drop table operation, when there is no database or transaction log backups available and no possibility to create a full database restore. Note: ApexSQL Recover supports recovery of BLOB values from database files (online, detached and db backups) only. Recovery of BLOB values from transaction log files is not supported yet. SOLUTION 1. Please make sure that you detached the db and backed up the raw MDF and LDF files. Doing full backup won’t do the trick as it will just backup pages in use and active part of transaction log whereas we need both deallocated pages and the entire transaction log to maximize chances of good recovery. 2. Once you have backed up the files please attach them as another database, put it into readonly mode. If this is not possible, than please put original database to readonly mode, the less post-incident activities is performed on database the more possibility for successful data recovery 3. Open ApexSQL Recover and point it to your SQL Server:  4. Select ‘Recovery lost data due to Drop operation’ recovery option  5. Specify database for recovery:  6. Select ‘several sources are available for data recovery’ option  7. Specify data sources:  8. Specify path for the recovery script and generate it:  9. Open generated recovery script and review that it contains required data:  10. Run it versus your database  SEE ALSO Recover from rogue delete statement with no backup, or without having to do a full restore Recover from a rogue truncate table statement with no backup, or without having to do a full restore Recover single table data from a database backup "row level recovery", without having to do a full restore Recovering a file from sharepoint database Recovering corrupted database Undoing schema changes (Drop Object) AUTHOR Dmitriy Dyubchenko LAST REVIEW DATE 13 August 2009 Labels: ApexSQL Recover |
© 2010 ApexSQL Tools All Rights Reserved | 1.919.968.8444 | Contact Us | Terms of Use | Privacy Policy