| LINKS |
|
ApexSQL Knowledgebase Tips and How-to Articles for ApexSQL Tools Undoing schema changes (Drop Object) APPLIES TO ApexSQL Recover 2008.06.0838 and below SUMMARY This article describes how to undo schema changes that occur as a result of a DROP [Object] operation. DESCRIPTION 1. Open ApexSQL Recover and point to your SQL Server:  2. Select the ‘Recover lost object due to a Drop [Object] operation’ recovery option  3. Specify the database for recovery:  4. Select the ‘Several sources are available for data recovery’ option.  5. Specify the available data sources:  6. Specify the path and the name for the recovery script and click ‘Finish’:  7. Open the generated recovery script and review its contents to verify it contains the required data:  8. Run the generated script against your database to recover the lost objects. 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 Recover a single table from a full database backup Recovering BLOB data from a SharePoint database Recovering corrupted database POSTED BY Dmitriy Dyubchenko LAST UPDATED 23 June 2010 Labels: ApexSQL Recover |
