This isn’t the same Steve Harris that used to work at Apria is it? Thanks, Mooney
Mark Mooney Senior Tivoli Consultant Advanced Integrated Solutions ITWS v8.5 : TSM v6.1 : TADDM v7.1 TAMIT v7.1 : TSRM v7.1 Certified Deployment Professional Cell : (321) 745-9315 Office : (714) 572-5600 -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Steve Harris Sent: Thursday, May 27, 2010 9:54 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Tdp sql questions Hi Gary what are you trying to accomplish with your frequent diffutils? How about this evening window - log backup (truncate=yes) followed by full backup every two hours - log backup (truncate=no) followed by VSS backup to local disk Configure it to keep 2 days of VSS snapshots, if you have the space If you need to restore your database, but still have the underlying disk, you can restore from the VSS copy and roll forward to the point of failure (or to the point where the DBA trashed something he shouldn't ) If you lose the disk, restore from full backup and roll forward your logs to the last available log backup. Have enough space in your storage pool to keep the whole day's log backups if restore time is an issue. Regards Steve Steven Harris TSM Admin Paraparaumu, New Zealand On Thu, 27 May 2010 11:47:16 -0400, "Lee, Gary D." <g...@bsu.edu> wrote: > 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