Backup is a critical part of database operations. Incremental backups can significantly reduce the performance load on a PostgreSQL server. This article covers the process of creating incremental backups of PostgreSQL on Windows, as well as restoring them. What is an Incremental Backup? An incremental backup is not a backup of the entire database, but … Read more

One of the key differences between PostgreSQL and other DBMSs is its large and diverse community, which creates a wide range of tools for working with and administering the system. This is undoubtedly a good thing, but sometimes such variety can be overwhelming — many tools exist for the same task, and it’s not always … Read more

Full database backups are a great thing, but creating them frequently can be inconvenient. If the database is large, the backup will also be large, and creating it can put a significant load on the server and the network when transferring the backup to storage. To avoid doing full backups all the time and to … Read more

By default, the SqlBak Docker container includes client utilities for working with databases, such as sqlcmd, mysql, mysqldump, psql, pg_dump, and pg_restore. However, these utilities may not be backward compatible with older database versions. For example, when connecting to a MySQL 8.1 database using the mysqldump utility from the Docker container, which is designed for MySQL … Read more

If your MySQL database is running in Docker, backing it up is no more complicated than backing up a database installed directly on the server. However, there are tips, tricks, and best practices that can simplify the process. Backup the database, not the container Although MySQL in Docker is ultimately just a program interacting with … Read more

Backup of virtual machines has long been the industry standard. While Docker is not a direct alternative to virtual machines, there are many similarities between them. So, how do you handle backup Docker containers? In this article, we will explore various approaches to backup Docker containers and their specific features. What should be backed up … Read more

In this article, we will review software designed for backing up SQL Server. Each tool has its own features and can be useful depending on the size of your architecture, availability of qualified specialists, financial resources and other factors. Free tools SQL Server Management Studio + SQL Server Agent The main tool for working with … Read more

Scheduling SQL Server backups can be done in various ways, including using SQL Server Agent, PowerShell, third-party tools or through scripts with Windows Scheduler. This article will explore different methods for scheduling MSSQL backups in more detail, as well as best practices for timing and frequency of scheduled backups. Tools for automating backups Scheduled automatic … Read more

In addition to the user databases that a SQL Server administrator can create, there are also system databases. The primary ones visible in Object Explorer are master, msdb, model and tempdb. All these databases, except for tempdb, support backup operations. In this article, we’ll discuss whether these databases need to be backed up, and if … Read more