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.

HAPPY NEW YEAR 2022

The dbSQWare team wishes you a very happy new year 2022!

This year again, we will put all our efforts to satisfy our customers and respond to the management and maintenance issues of DBMSs.
It is thanks to our users and it is for them that our dbSQWare software continues to evolve and incorporate new features.

Facilitating the daily life of DBA teams and their CIOs is our priority.

 

 

 

 

 

 

 

 

 

 

 

 

MERRY CHRISTMAS

The dbSQWare team wishes you a Merry CHRISTMAS 2021!
Have a wonderful holiday season.
We will meet again next year for new dbSQWariques shares.

THANK YOU!

THANK YOU !

THANKS to all our users for their loyalty!

It’s been 14 years since our first customers chose dbSQWare to operate and maintain their entire database.
In 14 years, the software has continued to evolve to meet the demands and needs of our users.
And each year, they know how to share their satisfaction with us by renewing their confidence.

Healthcare Meetings 2021

The Healthcare Meetings trade fair starts today!

After a first dinner last night between top decision-makers and exhibitors, today is the launch of the Healthcare Meetings show in Cannes.
For 2 days, this unprecedented event will be punctuated by one-to-one prequalified meetings and numerous exchanges in the field of health.
Michel Payan and Séverine Payan from the dbSQWare team will be on stand K05, to present our software dedicated to the management and maintenance of DBMSs.

The ideal opportunity to discuss with them on database engines, their management and associated issues.

IT Decision Makers Dinner

Dinner for IT decision-makers (DSI, RSSI, CDO, CTO, etc.) organized by the Club Informatique Provence Méditerranée – CIP, this evening at the Novotel Avignon Nord.

Our CEO, Michel Payan, accompanied by Emmy PAYAN, will participate in this exceptional IT event and will represent dbSQWare, sponsor of the CIP.
The theme of the evening will be: The Factory of the Future.

Congratulations to the members of the CIP for the organization of this event and good dinner to all the participants!

CRIP: M-1

The annual convention of the CRiP – Cercle des Décideurs IT is approaching!
See you in 1 month at Espace Champerret, in Paris, for this show organized by the Club of Infrastructure and Production Managers.

The dbSQWare team will be waiting for you at booth F06, on December 08 and 09.

Halloween

Trick or treat … In 2 days, it will be Halloween!

For the occasion, the dbSQWare team wishes you a happy party with family, friends or colleagues!

 

 

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.

WELCOME TO YOU

We are very happy to welcome 3 new work-study students to the dbSQWare team.

On the business side, Agnès Nagamany who is in Bachelor 3 – Sales & Negotiation at Euridis Business School joined us on 20/09.
On the IT side, Ruben Ruiz and Thomas PAYAN who are both in Bachelor 3 – IT at AIX YNOV CAMPUS are starting their work-study programs today.

Welcome to all 3!