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 <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 04/09/2001 11:48:51 AM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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
System Manager
Farm Income Programs Directorate
Winnipeg, MB, CA
[EMAIL PROTECTED]
ph: (204) 984-1602 fax: (204) 983-7557
-------------------------------------------------------------------------------------------
>>> [EMAIL PROTECTED] 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.