The most important thing in accounting is your database and the accumulated results of your work.
A special feature of Torgsoft is that the data belongs to you and is stored on your server or computer.
Whatever happens to the equipment — a hard drive fails, a computer is stolen, a server is encrypted by a virus — the program, licenses, and additional options can be restored. The only thing that cannot be restored is your commercial information if you have not saved a copy of it in advance.
Torgsoft does not have access to your database and does not store copies of your information on its servers. Backup is the responsibility of the business owner.
Be sure to create a database archive and store it outside the work computer: on a separate drive or in cloud storage, for example on Google Drive.
Three ways to save data
1. Manual database saving
Creating an archive is very easy: Torgsoft → File → Archiving → Save database. The program will create a file in .mir format or a compressed .mirz file, which takes up less space.
2. Creating an environment image
This is an extended archive: one file in .tsimg format stores not only the database, but also the folder with the program itself (settings, receipt templates) and the folder with product photos. The path is the same: File → Archiving → Create environment image. An environment image is convenient when you need to move the system to another computer or reinstall the program.
3. Automatic cloud archiving
To eliminate the human factor, use the additional option «Cloud Data Archive». According to a set schedule, it creates an archive of the database, the program folder, or photos and uploads it to your Google Drive, to the TORGSOFT_CLOUD folder.
This is protection against computer failure and ransomware viruses, because the copy is physically located outside your store or server. The file retention period is set in the settings, so old copies are deleted automatically and do not fill up the cloud storage.
Option settings: Settings → Scheduled tasks → Archiving to cloud storage tab.
Frequently asked questions about database archiving
Our server was encrypted by a virus. Does Torgsoft have a copy of our database?
No. Torgsoft does not store client databases on its resources. If local archives are also encrypted, it is impossible to restore the data. That is why we recommend uploading archives to independent drives or enabling the «Cloud Data Archive» option. If you find an intact archive on a flash drive or in the cloud, technical support will help restore work from it.
The option is enabled, but new archives do not appear on Google Drive
There may be several reasons:
- Google Drive has run out of space. The program cannot upload a new file. Empty the trash in the cloud storage or buy more space.
- Authorization failure. After changing the password or updating Google policies, access may be lost. Go to Settings → Scheduled tasks → Archiving to cloud storage and authorize again.
- Schedule time conflict. The time for creating the local archive (17:00 by default) must not coincide with the time of sending it to the cloud. For the cloud, set the time at least 10 minutes later, for example 17:10.
During archiving, an error appears about the PRIMARY filegroup being full
This means that the database has reached the 10 GB limit. This limitation applies to the free edition of Microsoft SQL Server Express, which most entrepreneurs use. To be able to create archives again:
- delete statistics of closed periods, that is, clear data for previous years;
- shrink the database using SQL Server Management Studio;
- if you do not need to delete history, switch to a paid edition of SQL Server, which has no database size limit.
When saving the database, an error appears about a path not found or syntax
The most common cause is Windows settings. If the date format in regional settings uses a slash, the system tries to create a file with prohibited characters in the name. The error also occurs when the database name contains special characters or single quotation marks. Solution: change the date separator to a dot and make sure that the archive path does not contain prohibited characters.
Can an archive be sent to the cloud without waiting for the schedule?
Yes. In the archiving task window, there is a Create archive now button. This is convenient before updating the program or before complex operations with goods.
How to move the database from an old computer to a new one?
- On the old computer, save the database: File → Archiving → Save database.
- Copy the .mir or .mirz file to a flash drive.
- Install Torgsoft on the new computer.
- Click File → Archiving → Load database and specify the path to the file.
If you need to move the database, photos, and receipt templates at once — use an environment image (.tsimg). During program installation, at the database setup step, select «Restore from image or cloud».
Go back to the previous step