Backup

Attunity Replicate: Backup & Restore a task

By a customer, we faced the question: how to backup and restore a replication task in Attunity Replicate? We don’t see any button or menu into the administration web console and in the Guide line, we haven’t really a(…)

SQL Server 2016: Extended Events are more powerful as Trace Flag for Backups and Restores

Before SQL Server 2016, we use Trace Flag to display information about backup and restore operations like the 3004, 3014, 3213 or 3604. Here a link to the MSDN with a great(…)

The dbi services PostgreSQL reference architecture (2) – The community approach

In the last post I looked at how dbi services designs a PostgreSQL architecture based on the products of EnterpriseDB. In this post I’ll look at the same questions but using pure community tools. If you(…)

The dbi services PostgreSQL reference architecture (1) – The commercial approach

When it comes to designing a PostgreSQL architecture that fits your requirements there are a couple of things to think about: Do you need a HA setup? How shall backups and restores being done and how shall all of these(…)

Managed Backup with SQL Server 2014

In a previous blog post called Backup a SQL Server database from On-Premise to Azure, I presented the different tools to backup your on-premise databases on Azure Storage. SQL Server Managed Backup to Windows Azure was one of(…)

Pgbarman : gestion de sauvegarde et récupération PostgreSQL

Fin 2012, j’ai présenté « pgbarman », une solution de sauvegarde et récupération pour PostgreSQL et décrit son installation. Pgbarman fournit un ensemble de commandes vous permettant la mise en œuvre de sauvegardes vers un serveur dédié. Le principal intérêt est à(…)

Oracle Database 12c: ACFS – un système de fichier pour vos bases

La version 12c d’Oracle Grid Infrastructure introduit de nombreuses nouveautés dans le support d’ACFS, le système de fichiers clusterisés d’Oracle. Nous abordons dans ce posting la capacité d’ACFS d’être le système de fichier de votre base de données ainsi que sa(…)

Oracle 12c Backup & Recovery: What’s new?

After months of waiting, Oracle Database 12c is finally available. In this posting, I am going to provide a summary of the new features of Oracle 12c in terms Backup and Recovery. Pluggable, what else? For sure, the most(…)

Barman: une solution pour vos backups PostgreSQL

L’objet de ce posting est de décrire la mise en place et l’utilisation d’un gestionnaire de sauvegarde pour un cluster de  base postgresql. Barman – acronyme de “backup recovery manager”- pour PostgreSQL est le logiciel sur lequel nous nous(…)

RMAN backup is failing due to “corrupt blocks”

Last week, I was not able to complete a backup because of the ORA-19566 error: “exceeded limit of 0 corrupt blocks”. Here is what you can do to fix it. Starting Point: backup error Here is(…)