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

Subject:	[ADSM-L] scripted restore of sql server database from diff backup
From:	"Schaub, Steve" <steve_schaub AT BCBST DOT COM>
To:	ADSM-L AT VM.MARIST DOT EDU
Date:	Thu, 29 Oct 2009 13:45:58 -0400

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

<Prev in Thread]

Current Thread

[Next in Thread>

Previous by Date:

[ADSM-L] Unsubscribe, Arthur Poon

Next by Date:

Re: [ADSM-L] TSM server move to new hardware, Keith Arbogast

Previous by Thread:

[ADSM-L] Unsubscribe, Arthur Poon

Next by Thread:

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

Indexes:

[Date] [Thread] [Top] [All Lists]