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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Lee, Gary D.
Sent: Thursday, May 27, 2010 8:47 AM
To: ADSM-L AT VM.MARIST DOT 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