Akash
When you do a database backup, do you specify type=full? The default is
incremental.
TSM will only let you delete up to the last FULL backup, because you need the
last full and all subsequent incrementals to get up to current date.
To solve your immediate problem, you might take another FULL backup. Then,
making sure that you understand the implications, run a delete dbb
todate=today. All those old database tapes will come available for reuse.
Steve Harris
TSM Admin
Queensland Health
Brisbane Australia
>>> akashj AT IBILTTECHNOLOGIES DOT COM 15/02/2005 14:44:05 >>>
Still I am not able to solve the problem and standing where I had started.
See when I do q drmedia, I receive certain volumes like
Volume Name State Last Update Automated
Date/Time LibName
---------------- ----------------- ------------------- ---------------
-
BT0081 Mountable 01/29/05 23:03:15
BT0085 Mountable 12/31/04 14:52:06
BT0082 Mountable 11/30/04 11:05:38
BT0084 Mountable 11/02/04 13:42:51
BT0083 Mountable 09/13/04 15:54:11
BT0080 Mountable 08/11/04 14:35:47
Now I want to delete BT0080 to reuse it for TSM backup.
Any help on this issue is really appreciated?
Regards
Akash
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Iain
Barnetson
Sent: Monday, 14 February 2005 11:37 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: TSM Database backup volume deletion
Importance: High
Well far from not being able to "afford" the tapes, I can't "afford" not
to be able to restore back that far.
As demonstrated recently when a "minor" issue prior to me leaving on two
weeks holiday, turned out to require a full restore from DB from before
the problem arose. Tricky to do with only 2 or 3 days DB backups ;)
Regards,
Iain Barnetson
IT Systems Administrator
UKN Infrastructure Operations
T: +44 1224 776913 M: +44 7787 916721 F: +44 1224 776641
Email: iain.barnetson AT halliburton DOT com
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
David E Ehresman
Sent: 14 February 2005 17:45
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] TSM Database backup volume deletion
>>I backup the DB each and every day, and before & after any changes,
and
keep (now at least) 28 days copies <<
Do you also have your offsite storagepool reuse delay set to 28 days?
If the data tapes have been reused, the data base backup will not do you
any good.
Since few of us can afford to keep 28 days worth of expired tapes
offsite, most of us only keep data base backups for 3-5 days.
David
***********************************************************************************
This email, including any attachments sent with it, is confidential and for the
sole use of the intended recipient(s). This confidentiality is not waived or
lost, if you receive it and you are not the intended recipient(s), or if it is
transmitted/received in error.
Any unauthorised use, alteration, disclosure, distribution or review of this
email is prohibited. It may be subject to a statutory duty of confidentiality
if it relates to health service matters.
If you are not the intended recipient(s), or if you have received this email in
error, you are asked to immediately notify the sender by telephone or by return
email. You should also delete this email and destroy any hard copies produced.
***********************************************************************************
|
