Miles,

You said, "I never do incrementals. Not of my 2 GB ADSM database nor my 30
GB Sybase database nor my 10 MB database that hardly changes. When you are
under the gun to get a database restored, incrementals can be hard to
restore if you are the administrator  and even harder if someone else is
trying to do the restore."

I'm with you on that one.

Every day I do a FULL DB backup of my 24 GB TSM database to DLT.  On a
little HP 418 that takes 1-3/4 hours.  Since that's a set-and-forget
operation, it just works OK (I check the results daily).

I think that's time well spent.

Tab Trepagnier
TSM Administrator
Laitram Corporation







Miles Purdy <PURDYM AT FIPD.GC DOT CA>@VM.MARIST.EDU> on 04/09/2001 11:48:51 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:
Subject:  Re: DATABASE backup question FULL or INCREMENTAL?


IMHO:
I never do incrementals. Not of my 2 GB ADSM database nor my 30 GB Sybase
database nor my 10 MB database that hardly changes. When you are under the
gun to get a database restored, incrementals can be hard to restore if you
are the administrator  and even harder if someone else is trying to do the
restore. How hard is it just to type when your boos in standing behind you?
Remember what KISS stands for?


-------------------------------------------------------------------------------------------
Miles Purdy
Miles Purdy
System Manager
Farm Income Programs Directorate
Winnipeg, MB, CA
purdym AT fipd.gc DOT ca
ph: (204) 984-1602 fax: (204) 983-7557
-------------------------------------------------------------------------------------------
>>> dbrowne AT HUMANA DOT COM 09-Apr-01 9:22:31 AM >>>
>>> dbrowne AT HUMANA DOT COM 09-Apr-01 9:22:31 AM >>>
I am doing a nightly database full backup with ADSM/TSM.  (TSM 3.7.4 on
OS390/2.10)
What is most commonly done a Full or Incremental?
What are the advantages/disadvantages of a full over an incremental backup
of the servers database?
The command we enter is as follows:
                      backup db type=full devclass=dboffsite
 Where dboffsite is the a tape device class.