Jim,

The restoration of the FULL and last DIFFFULL backup
followed by any log backups taken after the last DIFFFULL
is the correct procedure. If you are missing data in
your database, then something else must be going on here.

Thanks,

Del

----------------------------------------------------

"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on 07/02/2010
09:20:27 AM:

> [image removed]
>
> Junior DBA with a first time recovery of a ms-sql server using tdp...
>
> Jim Agnew/AC/VCU
>
> to:
>
> ADSM-L
>
> 07/02/2010 09:25 AM
>
> Sent by:
>
> "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>
> Please respond to "ADSM: Dist Stor Manager"
>
> Dear all,
>
> It's been quite an learning experience here the last couple days..  one
> of our biggest servers lost it's Raid system, and we had to rebuild..
>
> using TDP,
>
> of course, we restore the full backup, then the difffull, but does that
> include the logs that show up between the full and the difffull?  we do
> have data missing, is not using the intervening logs the culprit, even
> tho the differentials (should?) have gotten it?
>
> The senior DBA is attending a wedding overseas, and is out of touch.
> Hence the sortof Newbie question.
>
> Thanks one and all.