KB Article #67771

How to purge the files "binlog.XXXXX" for your Synchrony Database ?

Problem

-- How to purge the files "binlog.XXXXX" for your Synchrony Database ?


Resolution

-- These files are generated automaticaly and contain an incremental backup of your database.
  These files are located in the directory <SYNCHRONY_DATABASE>\binaries\data and are named binlog.XXXXX (where XXXXX is a figure between 000001 and 999999).
  If you want delete these backups to free some disk spaces by example, you need :
                1) perform a complete backup (<SYNCHRONY_DATABASE>\scripts\dbbackup)
2) stop your synchrony database (<SYNCHRONY_DATABASE>\scripts\dbstop)
3) move the files "binlog.XXXXX" into another directory. You can keep the last files, in case of you performed a complete backup recently.
4) edit the file : <SYNCHRONY_DATABASE>\binaries\data\binlog.index
   keep only the lines who referred to a file existing
By example, if you keep only the file "binlog.000001", so you must have only the following line in your binlog.index :
  .\binlog.000001
              If you move all files, you have just to delete the file named "binlog.index".
5) start the synchrony database (<SYNCHRONY_DATABASE>\scripts\dbstart

      WARNING : if your files are not in coherency, the synchrony database will not start after this operation.
          So, to be sure, perform a backup of all files (at the minimum : binlog.XXXXX + binlog.index)