Hi Steve,

You don't show the error messages, so it is difficult to guess what is
happening.
I assume you are restoring the DIFFERENTIAL as well as the previous FULL
when you perform the restore?
If so, is it possible something else is running a FULL backup, for
example, a snapshot tool?

Thanks,

Del

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


"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 09/02/2009
10:33:48 AM:

> [image removed]
>
> TDP-SQL behavior for diff backup of new databases
>
> Schaub, Steve
>
> to:
>
> ADSM-L
>
> 09/02/2009 10:34 AM
>
> Sent by:
>
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
> Please respond to "ADSM: Dist Stor Manager"
>
> Window 2003 Server, SQL Server 2005, TSM 5.5.1.0 TDP 5.5.1.0
>
> We are taking weekly full and daily diff backups of SQL databases using
TDP.
> What appears to happen if a database is created mid-week is that the
> DIFF backup appears to work, no errors are flagged.  However, an
> attempt to restore this database fails, complaining that it doesn't
> have a full backup.
>
> Can someone confirm the behavior I think we are seeing in TDP, and
> if there is a recommended workaround so that we don't get caught by it?
>
> 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