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:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 2:45 PM
To: [EMAIL PROTECTED]
Cc: Heinrich, Tilo
Subject: RE: Deleting unused backup history - Was: Adminstrating backup me diums
From: Christian Zink [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 2:45 PM
To: [EMAIL PROTECTED]
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
