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 >>> [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Behalf Of Iain Barnetson Sent: Monday, 14 February 2005 11:37 PM To: ADSM-L@VM.MARIST.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: [EMAIL PROTECTED] -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David E Ehresman Sent: 14 February 2005 17:45 To: ADSM-L@VM.MARIST.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. ***********************************************************************************