LINKS
General
Apex SQL Audit
Apex SQL Clean
Apex SQL Code
Apex SQL Data Diff
Apex SQL Debug
Apex SQL Diff
Apex SQL Diff API
Apex SQL Doc
Apex SQL Edit
Apex SQL Enforce
Apex SQL Log
Apex SQL Log API
Apex SQL Recover
Apex SQL Refactor
Apex SQL Report
Apex SQL Script
Apex SQL Source Ctl
Apex SQL SSIS Compare
Knowledgebase Home
Apex SQL Audit
Apex SQL Clean
Apex SQL Code
Apex SQL Data Diff
Apex SQL Debug
Apex SQL Diff
Apex SQL Diff API
Apex SQL Doc
Apex SQL Edit
Apex SQL Enforce
Apex SQL Log
Apex SQL Log API
Apex SQL Recover
Apex SQL Refactor
Apex SQL Report
Apex SQL Script
Apex SQL Source Ctl
Apex SQL SSIS Compare
Knowledgebase Home
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 Apex SQL Tools Recovering corrupted database DESCRIPTION This article describes how to recover corrupted database when detached MDF file and database backup are available only. Online database is completely corrupted at the same time. 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. Open ApexSQL Recover and point it to your SQL Server:  2. Select ‘Recover from corrupted database or detached mdf’ recovery option  3. Specify that there is not older online database is available:  4. Add detached MDF database file and its backup for recovery:  5. Specify tables for recovery:  6. Specify path for the recovery script and generate it:  7. Open generated recovery script and review that it contains required data:  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 Undoing schema changes (Drop Object) AUTHOR Dmitriy Dyubchenko LAST REVIEW DATE 14 August 2009 Labels: ApexSQL Recover |
© 2010 Apex SQL Tools All Rights Reserved | 1.919.968.8444 | Contact Us | Terms of Use | Privacy Policy