ADSM-L

Re: [ADSM-L] Tdp sql questions

2010-05-28 12:09:32
Subject: Re: [ADSM-L] Tdp sql questions
From: Mark Mooney <mmooney AT AISCONSULTING DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 28 May 2010 09:08:30 -0700
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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Steve Harris
Sent: Thursday, May 27, 2010 9:54 PM
To: ADSM-L AT VM.MARIST DOT 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." <GLEE AT BSU DOT 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
<Prev in Thread] Current Thread [Next in Thread>