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.

 

 

 

 

 

 

 

 

 

 

 

 

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.

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.

IT & IT Security Meetings 2021

Tonight, the IT and IT Security Meetings will begin with a dinner between top decision makers and exhibitors.
The following 2 days will take place at the Palais des Festivals et des Congrès in Cannes. They will be punctuated by one-to-one meetings and discussions within the show.

Michel Payan and Séverine Payan from the dbSQWare team will be present, for this IT event, on stand A15.

The opportunity to discuss database engines, their management, their issues and to present our software dedicated to the management and maintenance of DBMS.

FEATURES

dbSQWare is DBMS operation and maintenance software.
Constantly evolving for 15 years, it is able to operate and maintain, in a completely homogeneous manner, 11 types of database engines (Relational & amp; NoSQL).

Its main functions are:
– copying of environments
– backup and restore
– reorganization
– the Statistics update
– the dashboard / 360 ° vision
– customization

Very flexible, dbSQWare adapts to all businesses, regardless of their size and activity.

To discuss the subject, you will be able to meet our leaders, Michel Payan and Séverine Payan, at the IT and IT Security Meetings fair to be held at the Palais des Festivals et des Congrès in Cannes, on September 1 and 2.
See you on stand A15!

CIP

A little summer break …
Thank you to Club Informatique Provence Méditerranée – CIP for its nice bath towel!

Have a nice summer everyone.

Partner of the YEAR Award

It is with great pride that the dbSQWare team received the Partner of the Year award, on the occasion of the festive evening organized by the Club Informatique Provence Méditerranée – CIP.
Thank you to you, organizers of the Club, for this great reward and a big bravo for the course, without fail, of this pleasant evening which you made us live!
Friendliness, good humor and exchanges were at the rendezvous.

Congratulations also to the other winners: Denis ROUX for the IT decision maker of the year award and Dominique Lopez for the office Coup de Coeur award!

Can’t wait for the next event!

CIP FESTIVE EVENING

Festive evening organized by the Club Informatique Provence Méditerranée – CIP, this evening, at the Terrasses du Port in Marseille.

dbSQWare, sponsor of the CIP, will take part with great pleasure in this exceptional event, in this unique setting.
Theme of the evening: “Cruise” … Atmosphere guaranteed!

Bravo to the members of the CIP for the organization and good evening to all the participants!

SUMMER

The dbSQWare team wishes you a wonderful summer 2021.

May it bring you warmth, energy and enthusiasm to carry out your personal and professional projects!