KB Article #67771
How to purge the files "binlog.XXXXX" for your Synchrony Database ?
-- 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)