Thank you, Del!  That was what we'd guessed, and it is nice to know for
sure..  No data was reported missing, some was, but when I re-queryed
the user there was no answer..

Thanks again,

Jim Agnew

On 7/6/2010 10:51 AM, Del Hoobler wrote:

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.

--
"Don't be a phishing victim - VCU and other reputable organizations will
never use email to request that you reply with your password, social
security number or confidential personal information. For more details
visit http://infosecurity.vcu.edu/phishing.html";