Backups and auditing: how to protect your database and avoid losing data

Loss of business data is one of the greatest fears for an entrepreneur. Hardware failure, a virus attack that encrypts files, or a simple human error can destroy the results of many years of work in just a few minutes. These are not just numbers in tables; they are vital information without which a business comes to a halt.

Everything you have been building for so long is at risk: warehouse stock status, sales results, settlements with suppliers, customer database, payment records, financial documents, history, and most importantly the invested effort and time — the most valuable resource.

Fortunately, the days when backups were a complex and unreliable process are gone. Modern systems are not just an “insurance policy” in case of disaster. They are smart, flexible tools with non-obvious but powerful features that help not only protect data but also manage it efficiently. Let’s look at five such capabilities every business owner should know about.

Five backup features worth knowing

1. Not just a database, but the entire “environment image”

Many people believe that a backup is only a database archive. However, modern systems allow you to protect much more. The “Create environment image” function creates a single, complete archive (*.tsimg) that contains everything needed to fully restore a workstation:

• Database: all your commercial information.
• Program directory: settings and files of the accounting software itself.
• Directory with product photos: visual information that is important for online stores and catalogs.

The advantage of this approach is obvious: in case of a failure or when moving to a new computer, you can restore the entire system from a single file instead of configuring each component separately. This significantly simplifies and speeds up the recovery process.

2. “Smart” photo synchronization: saving time and space

Storing product photos in the cloud is a standard practice, but regular copying can quickly fill storage with outdated files. Intelligent synchronization with a cloud drive (for example, Google Drive) works much more efficiently. It does not blindly upload all files but operates according to clear rules:

• If a photo is changed on the local computer, it is automatically updated in the cloud storage as well.
• If a photo is deleted from the local directory, it is also deleted from the cloud.

This mechanism ensures that your cloud photo archive is always up to date. It also saves disk space because the system automatically removes unnecessary files that you have already deleted locally.

3. Avoid backup “collisions”: a critically important interval

This is one of those counterintuitive technical details that, if ignored, can lead to failures. You should not run the creation of a local archive (on your computer) and a cloud archive at the same time. These processes may conflict over access to the database file, which can result in damage to one of the archives or the complete failure of both tasks.

As experts, we recommend following a simple rule: always set a time interval between tasks.

For example:

• If the local archive is created by default at 17:00, then the task for creating the cloud archive should be scheduled no earlier than 17:10.
• If you have several cloud archiving tasks configured (for example, separately for the database and for photos), set an interval of at least 20–30 minutes between them.

This simple setup ensures that each task is performed correctly, guaranteeing the reliability of your backups.

4. How to turn 1 GB into 300 MB

The database size grows over time, and storing large archives in the cloud can become a problem, especially if you use a free plan with limited capacity. This is where the compression feature comes in.

By enabling the option “Compress archive before sending,” you can significantly reduce the file size. A practical example: a 1 GB database archive after compression may take only 300 MB. This not only saves space in your cloud storage but also significantly speeds up the upload process, especially with a slow internet connection.

5. Automatic cleanup: set the lifespan of old archives

Accumulating dozens or hundreds of old archives inevitably leads to disk overflow. Instead of deleting them manually, you can configure automatic management using the “File retention period” option. You can set how many days an archive is considered актуальним. After this period expires, the system can act in two ways:

• Completely delete old files. This is the simplest way to free up space.
• Move them to the cloud storage trash. This option provides an additional level of safety, as you can restore a file from the trash if needed. However, in this case, the trash will need to be emptied manually from time to time.

This function works on a “set it and forget it” principle, keeping your storage organized and preventing it from overflowing without your involvement.

Act proactively

As we can see, modern backup tools offer much more than simply creating a copy “just in case something happens.” This is a proactive data protection and management system that saves time, space, and nerves. Flexible settings, automation, and intelligent algorithms turn archiving from a routine necessity into a powerful tool for ensuring business stability.

Don’t wait for a problem to occur. Act proactively.

A lucky person is someone who did what others were only planning to do.

So, will you trust the protection of your most valuable asset to chance, or will you start acting proactively?