I'm not a DBA either, but you have to run a log backup after each full and each differential backup. The transaction log gets cleared down after a full. We schedule weekly full backups and differentials four times a day using five different schedules. The schedules are type=command and execute a local command procedure that in turn runs either \TDPSql\zdiff.cmd or zfull.cmd and then zlog.cmd. - Margaret
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Lee, Gary D. Sent: Thursday, May 27, 2010 8:47 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Tdp sql questions Tdp for sqlserver 5.5.3. tsm server 5.5.4. Trying to set up a backup regime for our physical plant. They have an app which uses sqlserver dbs. I am somewhat confused by the difference between a difffull and a log backup. What I want is a complete full each night, and diffs every two hours in between. Looking at diffs to save restore time and complexity. Warning, I am not a dba by any stretch of the imagination. How would I accomplish this? My inclination would be a difffull every two hours in between nightly fulls. But then what about the ever growing transaction log? Thanks for any clarification. Gary Lee Senior System Programmer Ball State University phone: 765-285-1310
