oh, yes i would also like to hear some ideas about that,
especially since we are running cca. 80 database archive logs backups
every 3 hours,
and some other kung-fu ...   and i've seen expire inventory and db
backups running at the
same time almost on daily basis.

ok, i have 3 db backups daily,  one on disk, other on tape device
class and third on
remote tsm

hi, my name is goran and i have flaw in my backup system.

On Wed, Dec 3, 2008 at 10:25 PM, Conradt, Jeremy
<JConradt AT ashleyfurniture DOT com> wrote:
> I have recently forced myself to admit we have a major flaw in our
> backup system.  What was happening and may be happening to many other
> people is we had maintenance processes, reclaims, migrations and so on
> happening on fileclass volumes after or even during the database backup.
> The problem with this is if the database were to crash or corrupt after
> its backup any maintenance work that happened after the beginning of the
> backup will cause issues with the recovery.
>
> For example X file exists on Filevolume1 at the beginning of the
> database backup but after the backup migration or reclamation moves it
> to Filevolume2.  The database corrupts we restore the database which
> doesn't know anything about Filevolume2 and now it can't find
> Filevolume1 which forces us to restore Filevolume1 from offsite.
> Basically just a lot of work to get everything back in sync.
>
> I have been working on trying to get all of our backup stg, migrate stg
> and reclaim stg to run in a single script sequentially but there is
> insufficient time in the day to complete successfully.  We end up
> overlapping into the next backup window which just slows everything
> down.
> The Copy pool "Offsite" tapes are fine because I have the stg set with a
> delay period of 1 day but I don't want to tie up file volume space for a
> day if I don't have to.
> I am wondering if anyone has worked their way through this issue and
> developed a good set of scripts to get everything running cleanly and in
> proper order.
>
> System Stats
> TSM Server version 5.3.5
> Windows 2003 SP2
>
> 1.1 TB Disk pool 15K Fiber channel san disk with DISK class volumes
>    Files smaller than 3GB are backed up to this location.
>    This pool is migrated to 0% every day.
>
> 3 TB file class volumes on 10K Fiber Channel san disk
>    Files larger than 3GB are backed up to this location.
>    This pool is migrated to 50% every day.
>
> 43 TB file class volumes on multiple disk drives primarily SATA.
>    Long term storage or data.
>
> In general we have about 32 TB of regular backup data and about 60 TB of
> Archive data on tape.
> We back up approximately 2 TB of data daily.
> At this time all of our backup data remains on disk.
>
> If anyone has any questions about how we have anything setup and working
> please let me know.
> If anyone has any suggestions on how to resolve any problems they see in
> our system please let me know.
> Thanks,
> Jeremy
>
>
>
>



--

Jim Bishop  - "Golf is played by twenty million mature American men
whose wives think they are out having f...