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!

 

 

Incontournable CIP Avignon

Tonight, afterwork “Incontournable Avignon” organized by the Club Informatique Provence Méditerranée – CIP.

Michel Payan will represent dbSQWare, sponsor of the CIP, at this event which will take place at the Novotel Avignon Nord in Sorgues and whose theme will be: the modernization of the IS.

Good event to all participants!

Healthcare Meetings : M-1

The Healthcare Meetings show is approaching!
See you in 1 month at the Palais des Festivals et des Congrès in Cannes for this one to one show, dedicated to health professionals.

The dbSQWare team will be waiting for you at booth K05 on November 24th and 25th.
The opportunity to discuss database engines, their management and their issues.