Introduction to ApexSQL Recover

Recover lost, missing or corrupted data due to DELETE, TRUNCATE and DROP operations. Recover tables and data from backups without restoring them. Recover from corrupt or detached databases. Recover deleted and online BLOBs as files. Get your fully functional 14-day free trial at http://www.apexsql.com/Download.aspx?

---

Closed Caption:

welcome to this introduction to apex
equal recover apex equal recover is an
invaluable tool when it comes to
recovering from a data disasters such as
a corrupt database or a drop table
especially when there are no backups
available FX equal recover has two types
of functions data recovery and data
extraction apex equal recover allows you
to recover lost data recover data from a
corrupted sequel database or detach
database files extract or cover blobs
from your databases files and extract
data from backups without having to
restore it first i'll demonstrate how to
recover a table that has been dropped
in $YEAR sequel server management studio
i will drop the adventureworks person .
person phone table as you can see the
person . person phone table is no longer
there now we will recover it by using
apex equal recover launch FX equal
recover select the option under data
recovery recover lost data due to a drop
table operation connect to the database
in which the table was dropped in this
case adventureworks 2012 then click Next
you will be presented with three options
regarding additional data sources the
first option is help me decide if you
select this option apex equal recover
will lead you through a series of
questions which will help you to figure
out which option to use based on the
answers you provide it will choose for
you
the second option is a transaction logs
use this option if you have log backups
or detached log files for this database
if you have any you should add them
since this will increase your chances of
a successful recovery an option three is
no additional transaction logs are
available choose this option if you know
that you don't have any backups for that
the online log has been truncated let's
select option three
next you can decide in which format to
recover you either cover to a script
file or to a new database
let's first recover to script
next you can select what to recover you
can recover both the table structures
and data recover only the table
structures or cover only the data we are
going to recover both the table
structures and data apex equal recover
will actually find all objects which
have been dropped and recover all
dropped objects click on the view script
button to view the script if the script
is too large for the internal editor you
have the option to save it or to open it
with an editor of your choice
as you can see the person . person phone
table is in there
next I will show you how to extract some
data from a backup without having to
restore it on the main screen select the
option from database backup
at the backup you want to use to recover
from brass the backup you want to use
then click Next
d select all
you can filter the list by object name
by typing the filter criteria here
select the table or tables you want to
extract and then click next select your
recovery option this time we will cover
to a new database
select whether to recover the structure
in the data or only the structure let's
get both the structure and the data
as you can see 16,000 624 Rose were
recovered if we look at sequel server we
can see that apex equal recover created
the database specified on the recovery
action step which now contains the
person . person phone table we can do
select almost able to see how apex
secret cover extracted the entire table
without having to wait four hours for a
backup to restore thank you for watching
this video