Incontournable CIP Nice-Sophia Antipolis_03/2022

This evening, afterwork “Incontournable Nice – Sophia Antipolis” organized by the Club Informatique Provence Méditerranée – CIP.

Michel Payan from dbSQWare will be present at this event which will take place at the Mercure Antibes Sophia Antipolis hotel and which will start at 6:30 p.m.
Exchanges, conviviality and networking will be there.

Good Essential to all!

DBMS: Backups

– “By the way, what’s the point of making database backups? »

As its name suggests, a database is a structured collection of data. It consists of files in which the data is stored.
It is created and managed by a database management system (DBMS) which, among other things, allows data to be recorded, searched for, sorted and modified.

Data is at the heart of business activity. It is extremely valuable and its loss can be devastating when there is no copy.
This is why it is essential to make backups of the databases.

There are several types of backup:
– the “full backup”: all the files of a database are copied
– the “incremental backup”: only the blocks of files that have been modified since the last backup are copied
– the “log backup” (redo log, transaction log, wal or xlog): transaction log files are copied. These files are used to memorize all the modifications carried out on a database.

Backups can be made:
– cold: when the database is stopped
– or hot: when the database is active.

Once the backups have been made, it is then possible to recover the data if necessary.

And since trust does not exclude control, it is a good idea to check compliance with the backup policy on a daily basis across the entire database.

BSPP & SDIS 13

The Paris Fire Brigade (BSPP) and the Bouches-du-Rhône Departmental Fire and Rescue Service (SDIS 13) have adopted dbSQWare.

With these 2 new collaborations, a new profession opens its doors to us: that of firefighters.
Responsible for the prevention, protection and fight against fire, firefighters also fulfill the missions of protection and rescue of people, prevention, protection and fight against accidents and disasters.

We are very happy that they have placed their trust in us and that our software can help them in their daily tasks of managing and maintaining their database.
Risk prevention, security and anticipation are part of the specific features of our software and the requirements that we share with them.