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" <[email protected]> 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" <[email protected]> > > 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
