Hi Steve,

You will need to do it in two steps. It will not automatically restore the
full.
There are customers that want this manual multiple-step behavior for other
reasons
which I am sure you can imagine.

Thanks,

Del

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

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 10/29/2009
01:45:58 PM:

> [image removed]
>
> scripted restore of sql server database from diff backup
>
> Schaub, Steve
>
> to:
>
> ADSM-L
>
> 10/29/2009 01:47 PM
>
> Sent by:
>
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
> Please respond to "ADSM: Dist Stor Manager"
>
> Tdp 5.5.2.0, Windows 2003 x64
> Not clear on this hopefully easy question - I need to batch script a
> nightly restore for cloning purposes, of a database backed up on a
> weekly-full, daily-diff schedule.
> If I use "tdpsqlc restore <dbname> diff etc..." will the tdp
> automatically restore the full and diff, or would I need to restore
> it in 2 steps, the full and then the diff?
>
> Thanks,
>
> Steve Schaub
> Systems Engineer, Windows
> BlueCross BlueShield of Tennessee
>
>
> -----------------------------------------------------
> Please see the following link for the BlueCross BlueShield of
> Tennessee E-mail disclaimer:  http://www.bcbst.com/email_disclaimer.shtm