From: Date: July 30 2003 7:01pm Subject: RE: Deleting unused backup history - Was: Adminstrating backup me diums List-Archive: http://lists.mysql.com/maxdb/17165 Message-Id: <37DE83A2B945D3118B180008C75D3E8D0AF2351B@dewdfx25.wdf.sap.corp> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C356BC.3C618410" This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C356BC.3C618410 Content-Type: text/plain; charset="iso-8859-1" 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 ------_=_NextPart_001_01C356BC.3C618410 Content-Type: text/html; charset="iso-8859-1" RE: Deleting unused backup history - Was: Adminstrating backup me diums
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

------_=_NextPart_001_01C356BC.3C618410--