RE: Deleting unused backup history - Was: Adminstrating backup me diums

[Tilo Heinrich]

Hello Chris,
 
the backup history does only contain information of occurred backups and restores. It was
never meant to represent the availability of backups, a task only achievable to a certain
degree anyway.
 
But if you would like to manipulate your backup history to not contain backups deleted
from the file system you could do so by deleting the corresponding backups from dbm.knl.
But please consider that the backups in the backup history relate to each other, e.g. if
you delete a complete backup, you should delete the incremental/differential backups
based on that backup as well (in the history and in the file system). If you would like
to keep all the backup history files short, you have to erase the corresponding entries
from dbm.mdf and dbm.ebf as well. Corresponding entries have the same key and label
(first 2 columns) in all three files. And make sure that the database kernel is not
changing the history at the same time as you (e.g. switch of auto save log and do no
backups or restores at this time).
 
Best Regards,
Tilo Heinrich
SAP Labs Berlin
 
-----Original Message-----
From: Christian Zink [mailto:chr.zink@stripped]
Sent: Wednesday, July 30, 2003 2:45 PM
To: sapdb.general@stripped
Cc: Heinrich, Tilo
Subject: RE: Deleting unused backup history - Was: Adminstrating backup me diums



Thx for your help, but by just deleting a backup file my backup histroy becomes
inconsistent. So my question: which files I have to edit, to avoid an inconsistent backup
history?

Thanx Chris 


Attachment: [text/html]

Attachment: [text/html]