Re: [ADSM-L] Tdp sql questions
2010-05-28 12:09:32
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
|
|
|