Re: [ADSM-L] TDP full-diff backups of SQLServer
2009-07-20 11:41:43
Only if you allow them to truncate the log.
My preference is to allow TDP to truncate the log, and then use the /notruncate
(or something like that) switch in their Maint Plans.... I guess you could
try to sync the timing of the jobs if there is a "quiet time" when there will
be no data changes.
thanks!
lisa consider the environment before printing
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of Schaub, Steve
> Sent: Monday, July 20, 2009 10:07 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: [ADSM-L] TDP full-diff backups of SQLServer
>
> W2K3 SQL Server 2000, 2003, 2008
> TDP 5.5.1.0
> We are currently doing daily full backups of all SQLServer databases,
> thinking of going to weekly full, daily diffs.
> One question I haven't been able to figure out is whether native
> full/diff backups done by the DBA's will mess up the ones from the TDP?
>
> 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
|
|
|