Home USU  ››  Programs for business automation  ››  Program for clinic  ››  Instructions for the medical program  ›› 


Database backup


Money These features must be ordered separately.

Until the thunder rolls...

Until the thunder rolls...

None of us think about bad things until something bad happens. And then the regrets start and the talk about what we could have done to prevent it. We suggest not to wait until the thunder strikes. Let's get straight to the very important topic of ' information retention '. Securing information is what needs to be done right now so that it is not too late later. ' Universal Accounting System ' can ensure the safety and security of information. But for this you need to take certain actions.

Program backup

Database backup

Data preservation is achieved by copying the database. A database backup is a backup of a program that uses a database. Usually, the database is used by any program that somehow works with information. Using a database means interacting with another program called ' database management system '. Abbreviated as ' DBMS '. And the problem is that you can not make a copy by simply copying the program files. The backup of the database must be done using special function calls of the ' database management system '.

What can cause a program to crash?

What can cause a program to crash?

Sudden power outage

The program runs on the server. The server is the hardware . Like any hardware, the server does not last forever. Any equipment has a bad habit of breaking down at the wrong time. Of course, this is a joke. There is no right time to break. None of us wait for something that we use to break.

It is especially tragic when the database breaks. This is extremely rare, but it does happen. Mostly due to a sudden power outage. For example, some data was entered into the database, and at that very moment the power was suddenly turned off. And you don't have an uninterruptible power supply. What will happen in this case? In this case, the database file will have time to fill only partially with all the information that you tried to add. The recording will not complete properly. The file will be broken.

Virus

Another example. You forgot to install an antivirus. A virus has been caught on the Internet that replaces, encrypts, or simply corrupts program files. That's all! After that, you will also not be able to use the infected program.

User actions

It happens that even the actions of users can ruin the software. There are two types of malicious activity: unintentional and intentional. That is, either a completely inexperienced computer user can unknowingly do something that will ruin the program. Or, on the contrary, a particularly experienced user can specifically harm the organization, for example, in the event of dismissal in the presence of a conflict with the head of the enterprise.

How to ensure stable, safe work?

How to ensure stable, safe work?

In the case of the program executable file, which has the extension ' EXE ', everything is simple. It will be enough for you to first copy this file once to an external storage medium, so that later the program can be restored from it in case of various failures.

But this is not the case with a database. It cannot be copied once at the beginning of work with the program. Because the database file changes every day. Every day you bring in new clients and new orders.

Also, the database file cannot be copied as a simple file. Because at the moment of copying the database may be in use. In this case, when copying, you may end up with a broken copy, which then you will not be able to use in case of various failures. Therefore, a copy from the database is made differently. Everyone needs a proper copy of the database.

Proper database copy

Proper database copy

The correct copy of the database is made not by simply copying a file, but by a special program. The special program is called ' Scheduler '. It is also developed by our company ' USU '. Scheduler is configurable. You can specify convenient days and times when you want to make a copy of the database.

It is best to take a copy every day. Archive a copy. Then add the current date and time to the name of the resulting archive so that you know exactly what date each copy is from. After that, the renamed archive is copied to other similar archives on another storage medium. Both the working database and its copies should not be stored on the same disk. It is not safe. On a separate hard drive, it is better to have several copies of the database from different dates. This is how it is most reliable. It is precisely according to this algorithm that the ' Scheduler ' program makes a copy in automatic mode. This is how a reliable copy of the database is made.

Order a database copy

Order a database copy

You can order reliable and correct copying of the database right now.

Database in the cloud

Database in the cloud

Important As an addition, you can also order the placement of the database in the cloud . This can also save your program if the personal computer breaks down.




See below for other helpful topics:


Your opinion is important to us!
Was this article helpful?




Universal Accounting System
2010 - 2024