Re: [ADSM-L] scripted restore of sql server database from diff backup

Thanks Del.  I'm assuming the full recovery has to be done with the /recover=no 
option in order for the following diff to be successful?
-steve

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Del Hoobler
Sent: Friday, October 30, 2009 7:36 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] scripted restore of sql server database from diff backup

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

-----------------------------------------------------
Please see the following link for the BlueCross BlueShield of Tennessee E-mail 
disclaimer:  http://www.bcbst.com/email_disclaimer.shtm