Sign Up

SqlBak Blog

Ivan Gusev

Complete guide to restoring SQL databases from BAK files in SQL Server

by

Restoring SQL Server databases from backup files is an important task for database administrators. In this article, we will discuss what backup files are and how to load a BAK file into SQL Server.

 

What are BAK files in SQL Server?

BAK files are files created by SQL Server, with the file extension .bak, that contain one or more backups of SQL Server databases. They are designed to restore databases to the state they were in at the time the backup was created.

These files are a physical copy of the data from the database files (.mdf и .ldf) and are not intended to be viewed directly in a text editor.

Importing a BAK file in SQL Server involves restoring a database. You can restore databases from these files using T-SQL commands, graphical utilities such as SQL Server Management Studio or SQLBackupAndFTP, as well as from the command line.

There are several graphical user interface tools available.

Read more

Integrating SqlBak with Zabbix: monitoring and backup execution

by

SqlBak has an API that allows it to integrate with other applications and services. This article explains how to integrate SqlBak and Zabbix. Sending job results to Zabbix 1. Export the template to Zabbix. It contains items for job results (status, date, backup type). Create a JSON file with the following content: { “zabbix_export”: { … Read more

SQL Server backup encryption: why and how?

by

This article will address the issue of backup encryption, why it is important, and the various approaches available. Why encrypt backups? Application-level encryption and “always encrypted” Simple backup encryption (7zip) SQL Server backup encryption Creating a certificate IMPORTANT: certificate backup Creating a backup with built-in encryption in SQL Server Restoring an encrypted SQL Server backup … Read more

SQL Server backup monitoring guide

by

In this article, various methods of monitoring backups and restores of SQL Server databases will be discussed, including tracking current progress and history. Tracking the status of your initiated backup If you initiate a backup yourself, you can instruct SQL Server to log the progress status by adding the WITH STATS parameter to the BACKUP … Read more

Simple SQL server backup guide for Linux

by

This simple guide will help you create backups of SQL Server on Linux.

SQL Server backups on Windows and Linux: what’s the difference?

The only noticeable difference is in the graphical tools.

SSMS is the main tool for SQL Server and is only available on Windows. Connecting from Windows to SQL Server on Linux is not always possible due to port security (1433). You will have to use the command line utility sqlcmd and T-SQL commands.

Read more

SqlBak Documentation

by

Documentation for the SqlBak product is currently under development. We apologize for any inconvenience.

While the documentation is being finalized, you can reach out to us through our support service, and we will strive to respond to your inquiry within a few hours.

Below is a list of articles from our blog where you can find useful materials on using SqlBak:

Read more

SQL Server Log Shipping

by

What is log shipping in SQL Server?

Log shipping in Microsoft SQL Server is an automated solution for master-slave replication based on the transfer of transaction logs from primary to secondary servers. This process ensures continuous database cloning while minimizing the load on the primary server.

Read more

Over SSH – Remote MySQL Backup & Dump Transfer

by

What is SSH

SSH (Secure Shell) is a method of secure data transmission over a network.

Administrators often encounter it when connecting to a Linux server by entering the command ssh userName@hostAddress, which allows them to execute commands on the remote server.

However, it is primarily a protocol, and on top of it, you can not only transmit data but also create SSH tunnels, allowing applications to transfer data over SSH.

Read more