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