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.

V2021.07

We couldn’t end the year without releasing a new version of our DBMS management and maintenance software.

With new features like:
– the user access report to databases for administrators, by API
– the management of inclusion and exclusion users
– the management of Oracle clusters configuration

And other changes to quickly discover in V2021.07 from dbSQWare!

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!

V2021.05

The 2021.05 version of dbSQWare has just been released!

Among the new features of this version are:
– the regeneration of the user’s cache from their profile,
– updating of rights in menu management.

Not to mention that dbSQWare is the only DBMS management and maintenance software capable of homogeneously managing 11 types of database engines.

SGBD

dbSQWare, our multi-DBMS operation and maintenance software supports 11 types of database engines.

On RDBMS side (Relational Database Management System):
=> Oracle, the most popular on UNIX / Linux
==> SQLServer, developed by Microsoft and mainly deployed on Windows
===> Teradata, a historic RDBMS with colossal storage capacities
====> Sybase, acquired by SAP and former market leader
=====> DB2 LUW, the distributed system version of the Mainframe engine
======> Ingres, dating from the 80s and in Open Source since 2004
=======> MySQL, the most popular open source RDBMS
========> PostgreSQL, the most advanced open source RDBMS

On NoSQL side:
=> Cassandra and her column-oriented organization
==> MongoDB, the most popular of NoSQL, with a document-oriented organization
===> Adabas Linux version, accessible through the natural language.

Despite the diversity of these database engines and their heterogeneity, with dbSQWare, their operation and maintenance are completely homogeneous.

V2021.04

Version 2021.04 of dbSQWare has been released!

This version includes 3 new features that should please our users:
– monitoring the execution of SQLServer jobs,
– generation of AWRs in RAC mode,
– monitoring of changes in the repository (addition / deletion of instances, patch / upgrade of versions).

Not to mention that dbSQWare is the only DBMS management and maintenance software capable of homogeneously managing 11 types of database engines.

V2021.03

The version 2021.03 of dbSQWare is released!

With a novelty that was in preparation when the previous version was released: the addition of a handrail for each managed DBMS and each of its instances.
A plus for our users who will be able to enter all the notifications necessary to gain visibility, information, time and management.

V2021.02

The version 2021.02 of dbSQWare has just been released!
With a novelty that should please: the ability to view and add general notes for each DBMS managed and each of its instances.
The addition of a handrail is in preparation and will be available in the next version.
A plus for our users who will gain visibility and information, both on history and on current affairs.

Not to mention that dbSQWare is the only DBMS management and maintenance software capable of managing 11 types of database engines.

V2021.01

New year … New version …
The dbSQWare team is pleased to announce the release of version 2021.01 of its software.
With the addition of a major feature:
–> access to all the tables visible in the graphical interface via Rest type APIs. More than 1400 paintings are affected by this novelty.
The other changes are visible in the Releases Notes section of our website.

Not to mention that dbSQWare is the only DBMS management and maintenance software, capable of homogeneously managing 11 different types of database engines, thus offering its users a similar approach and vision whatever the DBMS concerned.

V2020.07

Version 2020.07 of dbSQWare has just been released!
With several new features …
Among them, the customization of alert and weather emails and the possibility of directly accessing SQWareCentral indicators from the web interface of our software.
A plus for our users who will gain in visibility and speed.

Without forgetting that dbSQWare is the only DBMS management and maintenance software capable of homogeneously managing 11 types of database engines.