Solutions Products Download Purchase Support News Members Company
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


Undoing schema changes (Drop Object)

DESCRIPTION
This article describes how to undoing schema changes occurred by DROP [Object] operation.

SOLUTION
1. Open ApexSQL Recover and point it to your SQL Server:


2. Select ‘Recover lost object due to a Drop [Object] operation’ recovery option


3. Specify database for recovery:


4. Select ‘several sources are available for data recovery’ option


5. Specify data sources:


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


7. Open generated recovery script and review that it contains required data:


8. Run generate script versus your database to recover lost objects

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 from a rogue drop 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

AUTHOR
Dmitriy Dyubchenko

LAST REVIEW DATE
14 August 2009

Labels:



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