Compatibility: Version 6.8.x and 2003

Question:
I am testing my backups and database. I would like to change the number of the backup set back to 1 when I am ready to ship my application. How do I go about doing so?

Answer:
To do this, you will have to understand that the backup set number can only be read procedurally, not modified. This number will be incremented automatically with each backup.

Since the backup set number is stored with the data file, we have two ways to solve this problem.

1) We may simply use a new data file.

2) We can open the database up with 4D Tools and perform a "Recover by tags" on the data file. This option will re-build your data file to a new file, with the backup set number set to 1. Also, make sure that you remove all back up related files in respect with the last backup, such as the backup journal, or journal.txt files.